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.AST_RS_CAMP_PUB dependencies on FND_API

Line 40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,

36: -- End of Comments
37:
38: TYPE rs_camp_Rec_Type IS RECORD
39: (
40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,

Line 41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

37:
38: TYPE rs_camp_Rec_Type IS RECORD
39: (
40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,

38: TYPE rs_camp_Rec_Type IS RECORD
39: (
40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 43: START_DATE DATE := FND_API.G_MISS_DATE,

39: (
40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 44: END_DATE DATE := FND_API.G_MISS_DATE,

40: RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,

41: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

42: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

43: START_DATE DATE := FND_API.G_MISS_DATE,
44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 48: CREATION_DATE DATE := FND_API.G_MISS_DATE,

44: END_DATE DATE := FND_API.G_MISS_DATE,
45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52: );

Line 49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

45: STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52: );
53:

Line 50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

46: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52: );
53:
54: G_MISS_rs_camp_REC rs_camp_Rec_Type;

Line 51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR

47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: CREATION_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51: LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52: );
53:
54: G_MISS_rs_camp_REC rs_camp_Rec_Type;
55: TYPE rs_camp_Tbl_Type IS TABLE OF rs_camp_Rec_Type

Line 74: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

70: -- Pre-Req :
71: -- Parameters:
72: -- IN
73: -- p_api_version_number IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
76: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
77: --
78: -- OUT:

Line 75: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

71: -- Parameters:
72: -- IN
73: -- p_api_version_number IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
76: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
77: --
78: -- OUT:
79: -- x_return_status OUT VARCHAR2

Line 90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

86: -- End of Comments
87: --
88: PROCEDURE Create_rs_camp(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: P_rs_camp_Rec IN rs_camp_Rec_Type := G_MISS_rs_camp_REC,
93: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
94: X_RS_CAMPAIGN_ID OUT NUMBER,

Line 91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

87: --
88: PROCEDURE Create_rs_camp(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: P_rs_camp_Rec IN rs_camp_Rec_Type := G_MISS_rs_camp_REC,
93: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
94: X_RS_CAMPAIGN_ID OUT NUMBER,
95: X_Return_Status OUT VARCHAR2,

Line 109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

105: -- Pre-Req :
106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
113: --

Line 110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
113: --
114: -- OUT:

Line 127: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

123: --
124: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125: PROCEDURE Update_rs_camp(
126: P_Api_Version_Number IN NUMBER,
127: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
129: P_Identity_Salesforce_Id IN NUMBER := NULL,
130: P_rs_camp_Rec IN rs_camp_Rec_Type,
131: X_Return_Status OUT VARCHAR2,

Line 128: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

124: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125: PROCEDURE Update_rs_camp(
126: P_Api_Version_Number IN NUMBER,
127: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
129: P_Identity_Salesforce_Id IN NUMBER := NULL,
130: P_rs_camp_Rec IN rs_camp_Rec_Type,
131: X_Return_Status OUT VARCHAR2,
132: X_Msg_Count OUT NUMBER,

Line 145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

141: -- Pre-Req :
142: -- Parameters:
143: -- IN
144: -- p_api_version_number IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
148: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
149: --

Line 146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

142: -- Parameters:
143: -- IN
144: -- p_api_version_number IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
148: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
149: --
150: -- OUT:

Line 164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

160: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
161: -- The Master delete procedure may not be needed depends on different business requirements.
162: PROCEDURE Delete_rs_camp(
163: P_Api_Version_Number IN NUMBER,
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
166: P_identity_salesforce_id IN NUMBER := NULL,
167: P_rs_camp_Rec IN rs_camp_Rec_Type,
168: X_Return_Status OUT VARCHAR2,

Line 165: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

161: -- The Master delete procedure may not be needed depends on different business requirements.
162: PROCEDURE Delete_rs_camp(
163: P_Api_Version_Number IN NUMBER,
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
166: P_identity_salesforce_id IN NUMBER := NULL,
167: P_rs_camp_Rec IN rs_camp_Rec_Type,
168: X_Return_Status OUT VARCHAR2,
169: X_Msg_Count OUT NUMBER,

Line 182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

178: -- Pre-Req :
179: -- Parameters:
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
184: -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
185: -- Hint: Add List of bind variables here
186: -- p_rec_requested IN NUMBER Optional Default = 30

Line 192: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

188: --
189: -- Return Total Records Count Flag. This flag controls whether the total record count
190: -- and total record amount is returned.
191: --
192: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- Hint: User defined record type
194: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
195: --
196: -- OUT:

Line 214: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

210: -- End of Comments
211: --
212: PROCEDURE Get_rs_camp(
213: P_Api_Version_Number IN NUMBER,
214: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
215: P_identity_salesforce_id IN NUMBER := NULL,
216: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
217: -- Hint: Add list of bind variables here
218: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 220: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

216: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
217: -- Hint: Add list of bind variables here
218: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
219: p_start_rec_prt IN NUMBER := 1,
220: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
221: -- Hint: user defined record type
222: p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,
223: x_return_status OUT VARCHAR2,
224: x_msg_count OUT NUMBER,