eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PMT_PLANS_PUB dependencies on CN_API

Line 16: (PMT_PLAN_NAME cn_pmt_plans.name%TYPE := CN_API.G_MISS_CHAR,

12: --
13: -- Record type for Srp Payment Plan
14: --
15: TYPE srp_pmt_plans_rec_type IS RECORD
16: (PMT_PLAN_NAME cn_pmt_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
18: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
19: START_DATE cn_srp_pmt_plans.start_date%TYPE
20: := CN_API.G_MISS_DATE,

Line 17: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,

13: -- Record type for Srp Payment Plan
14: --
15: TYPE srp_pmt_plans_rec_type IS RECORD
16: (PMT_PLAN_NAME cn_pmt_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
18: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
19: START_DATE cn_srp_pmt_plans.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_srp_pmt_plans.end_date%TYPE

Line 18: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,

14: --
15: TYPE srp_pmt_plans_rec_type IS RECORD
16: (PMT_PLAN_NAME cn_pmt_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
18: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
19: START_DATE cn_srp_pmt_plans.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_srp_pmt_plans.end_date%TYPE
22: := CN_API.G_MISS_DATE,

Line 20: := CN_API.G_MISS_DATE,

16: (PMT_PLAN_NAME cn_pmt_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
18: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
19: START_DATE cn_srp_pmt_plans.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_srp_pmt_plans.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
24: := CN_API.G_MISS_NUM,

Line 22: := CN_API.G_MISS_DATE,

18: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
19: START_DATE cn_srp_pmt_plans.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_srp_pmt_plans.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
24: := CN_API.G_MISS_NUM,
25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
26: := CN_API.G_MISS_NUM,

Line 24: := CN_API.G_MISS_NUM,

20: := CN_API.G_MISS_DATE,
21: END_DATE cn_srp_pmt_plans.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
24: := CN_API.G_MISS_NUM,
25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
26: := CN_API.G_MISS_NUM,
27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,
28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,

Line 26: := CN_API.G_MISS_NUM,

22: := CN_API.G_MISS_DATE,
23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
24: := CN_API.G_MISS_NUM,
25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
26: := CN_API.G_MISS_NUM,
27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,
28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,
29: SRP_ROLE_ID cn_srp_pmt_plans.srp_role_id%TYPE,
30: ROLE_PMT_PLAN_ID cn_srp_pmt_plans.role_pmt_plan_id%TYPE,

Line 49: -- Default = CN_API.G_FALSE

45: -- Desc : Procedure to create a new payment plan assignment to salesrep
46: -- Parameters :
47: -- IN : p_api_version IN NUMBER Require
48: -- p_init_msg_list IN VARCHAR2 Optional
49: -- Default = CN_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional
51: -- Default = CN_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional
53: -- Default = CN_API.G_VALID_LEVEL_FULL

Line 51: -- Default = CN_API.G_FALSE

47: -- IN : p_api_version IN NUMBER Require
48: -- p_init_msg_list IN VARCHAR2 Optional
49: -- Default = CN_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional
51: -- Default = CN_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional
53: -- Default = CN_API.G_VALID_LEVEL_FULL
54: -- p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type
55: -- Required input :

Line 53: -- Default = CN_API.G_VALID_LEVEL_FULL

49: -- Default = CN_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional
51: -- Default = CN_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional
53: -- Default = CN_API.G_VALID_LEVEL_FULL
54: -- p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type
55: -- Required input :
56: -- PMT_PLAN_NAME payment plan name
57: -- SALESREP_TYPE,EMP_NUM use to get salesrep info

Line 94: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,

90: */
91: PROCEDURE Create_Srp_Pmt_Plan
92: (
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
95: p_commit IN VARCHAR2 := CN_API.G_FALSE,
96: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,

Line 95: p_commit IN VARCHAR2 := CN_API.G_FALSE,

91: PROCEDURE Create_Srp_Pmt_Plan
92: (
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
95: p_commit IN VARCHAR2 := CN_API.G_FALSE,
96: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,

Line 96: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,

92: (
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
95: p_commit IN VARCHAR2 := CN_API.G_FALSE,
96: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type,

Line 132: -- Default = CN_API.G_FALSE

128: -- Desc : Procedure to update pmt plan assignment of an salesrep
129: -- Parameters :
130: -- IN : p_api_version IN NUMBER Require
131: -- p_init_msg_list IN VARCHAR2 Optional
132: -- Default = CN_API.G_FALSE
133: -- p_commit IN VARCHAR2 Optional
134: -- Default = CN_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional
136: -- Default = CN_API.G_VALID_LEVEL_FULL

Line 134: -- Default = CN_API.G_FALSE

130: -- IN : p_api_version IN NUMBER Require
131: -- p_init_msg_list IN VARCHAR2 Optional
132: -- Default = CN_API.G_FALSE
133: -- p_commit IN VARCHAR2 Optional
134: -- Default = CN_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional
136: -- Default = CN_API.G_VALID_LEVEL_FULL
137: -- p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type
138: -- Required input :

Line 136: -- Default = CN_API.G_VALID_LEVEL_FULL

132: -- Default = CN_API.G_FALSE
133: -- p_commit IN VARCHAR2 Optional
134: -- Default = CN_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional
136: -- Default = CN_API.G_VALID_LEVEL_FULL
137: -- p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type
138: -- Required input :
139: -- PMT_PLAN_NAME payment plan name
140: -- SALESREP_TYPE,EMP_NUM use to get salesrep info

Line 182: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,

178:
179: PROCEDURE Update_Srp_Pmt_Plan
180: (
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
183: p_commit IN VARCHAR2 := CN_API.G_FALSE,
184: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,

Line 183: p_commit IN VARCHAR2 := CN_API.G_FALSE,

179: PROCEDURE Update_Srp_Pmt_Plan
180: (
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
183: p_commit IN VARCHAR2 := CN_API.G_FALSE,
184: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,

Line 184: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,

180: (
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
183: p_commit IN VARCHAR2 := CN_API.G_FALSE,
184: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_old_srp_pmt_plans_rec IN srp_pmt_plans_rec_type,

Line 221: -- Default = CN_API.G_FALSE

217: -- Desc : Procedure to delete a payment plan assignment to salesrep
218: -- Parameters :
219: -- IN : p_api_version IN NUMBER Require
220: -- p_init_msg_list IN VARCHAR2 Optional
221: -- Default = CN_API.G_FALSE
222: -- p_commit IN VARCHAR2 Optional
223: -- Default = CN_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional
225: -- Default = CN_API.G_VALID_LEVEL_FULL

Line 223: -- Default = CN_API.G_FALSE

219: -- IN : p_api_version IN NUMBER Require
220: -- p_init_msg_list IN VARCHAR2 Optional
221: -- Default = CN_API.G_FALSE
222: -- p_commit IN VARCHAR2 Optional
223: -- Default = CN_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional
225: -- Default = CN_API.G_VALID_LEVEL_FULL
226: -- p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type
227: -- Required input :

Line 225: -- Default = CN_API.G_VALID_LEVEL_FULL

221: -- Default = CN_API.G_FALSE
222: -- p_commit IN VARCHAR2 Optional
223: -- Default = CN_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional
225: -- Default = CN_API.G_VALID_LEVEL_FULL
226: -- p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type
227: -- Required input :
228: -- PMT_PLAN_NAME payment plan name
229: -- SALESREP_TYPE,EMP_NUM use to get salesrep info

Line 262: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,

258: */
259: PROCEDURE Delete_Srp_Pmt_Plan
260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
263: p_commit IN VARCHAR2 := CN_API.G_FALSE,
264: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,

Line 263: p_commit IN VARCHAR2 := CN_API.G_FALSE,

259: PROCEDURE Delete_Srp_Pmt_Plan
260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
263: p_commit IN VARCHAR2 := CN_API.G_FALSE,
264: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,

Line 264: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,

260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
263: p_commit IN VARCHAR2 := CN_API.G_FALSE,
264: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type,