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_GRP_CAMP_PUB dependencies on FND_API

Line 39: GROUP_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,

35: -- End of Comments
36:
37: TYPE grp_camp_Rec_Type IS RECORD
38: (
39: GROUP_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
40: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
41: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
42: START_DATE DATE := FND_API.G_MISS_DATE,
43: END_DATE DATE := FND_API.G_MISS_DATE,

Line 40: GROUP_ID NUMBER := FND_API.G_MISS_NUM,

36:
37: TYPE grp_camp_Rec_Type IS RECORD
38: (
39: GROUP_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
40: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
41: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
42: START_DATE DATE := FND_API.G_MISS_DATE,
43: END_DATE DATE := FND_API.G_MISS_DATE,
44: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 41: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,

37: TYPE grp_camp_Rec_Type IS RECORD
38: (
39: GROUP_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
40: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
41: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
42: START_DATE DATE := FND_API.G_MISS_DATE,
43: END_DATE DATE := FND_API.G_MISS_DATE,
44: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
45: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 42: START_DATE DATE := FND_API.G_MISS_DATE,

38: (
39: GROUP_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
40: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
41: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
42: START_DATE DATE := FND_API.G_MISS_DATE,
43: END_DATE DATE := FND_API.G_MISS_DATE,
44: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
45: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
46: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 43: END_DATE DATE := FND_API.G_MISS_DATE,

39: GROUP_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
40: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
41: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
42: START_DATE DATE := FND_API.G_MISS_DATE,
43: END_DATE DATE := FND_API.G_MISS_DATE,
44: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
45: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
46: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

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

40: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
41: CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
42: START_DATE DATE := FND_API.G_MISS_DATE,
43: END_DATE DATE := FND_API.G_MISS_DATE,
44: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
45: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
46: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 45: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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

Line 46: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

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

Line 48: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 49: CREATION_DATE DATE := FND_API.G_MISS_DATE

45: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
46: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE
50: );
51:
52: G_MISS_grp_camp_REC grp_camp_Rec_Type;
53: TYPE grp_camp_Tbl_Type IS TABLE OF grp_camp_Rec_Type

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

68: -- Pre-Req :
69: -- Parameters:
70: -- IN
71: -- p_api_version_number IN NUMBER Required
72: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
75: --
76: -- OUT:

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

69: -- Parameters:
70: -- IN
71: -- p_api_version_number IN NUMBER Required
72: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
75: --
76: -- OUT:
77: -- x_return_status OUT VARCHAR2

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

84: -- End of Comments
85: --
86: PROCEDURE Create_grp_camp(
87: P_Api_Version_Number IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: P_grp_camp_Rec IN grp_camp_Rec_Type := G_MISS_grp_camp_REC,
91: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
92: X_GROUP_CAMPAIGN_ID OUT NUMBER,

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

85: --
86: PROCEDURE Create_grp_camp(
87: P_Api_Version_Number IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: P_grp_camp_Rec IN grp_camp_Rec_Type := G_MISS_grp_camp_REC,
91: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
92: X_GROUP_CAMPAIGN_ID OUT NUMBER,
93: X_Return_Status OUT VARCHAR2,

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

103: -- Pre-Req :
104: -- Parameters:
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
110: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
111: --

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

104: -- Parameters:
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
110: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
111: --
112: -- OUT:

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

121: --
122: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
123: PROCEDURE Update_grp_camp(
124: P_Api_Version_Number IN NUMBER,
125: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
126: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
127: P_Identity_Salesforce_Id IN NUMBER := NULL,
128: P_grp_camp_Rec IN grp_camp_Rec_Type,
129: X_Return_Status OUT VARCHAR2,

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

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

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

139: -- Pre-Req :
140: -- Parameters:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
146: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
147: --

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

140: -- Parameters:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
146: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
147: --
148: -- OUT:

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

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

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

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

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

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

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

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

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

208: -- End of Comments
209: --
210: PROCEDURE Get_grp_camp(
211: P_Api_Version_Number IN NUMBER,
212: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
213: P_identity_salesforce_id IN NUMBER := NULL,
214: P_grp_camp_Rec IN ast_grp_camp_PUB.grp_camp_Rec_Type,
215: -- Hint: Add list of bind variables here
216: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

214: P_grp_camp_Rec IN ast_grp_camp_PUB.grp_camp_Rec_Type,
215: -- Hint: Add list of bind variables here
216: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
217: p_start_rec_prt IN NUMBER := 1,
218: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
219: -- Hint: user defined record type
220: p_order_by_rec IN ast_grp_camp_PUB.grp_camp_sort_rec_type,
221: x_return_status OUT VARCHAR2,
222: x_msg_count OUT NUMBER,