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.

[Home] [Help]

APPS.GCS_ADJ_APPROVAL_WF_PKG dependencies on GCS_ENTRY_HEADERS

Line 92: l_entry_id gcs_entry_headers.entry_id%type;

88: l_api_name constant varchar2(200) := 'fch_check_approvals';
89: l_debug_info VARCHAR2(2000);
90: l_calling_sequence VARCHAR2(2000);
91:
92: l_entry_id gcs_entry_headers.entry_id%type;
93:
94: l_user_name t_user_name%TYPE;
95: l_submitter_orig_system t_orig_system%TYPE;
96: l_submitter_id t_id%TYPE;

Line 101: l_entity_id gcs_entry_headers.entity_id%type;

97: l_submitter_name t_name%TYPE;
98: l_submitter_display_name t_display_name%TYPE;
99:
100: l_request_id NUMBER(15);
101: l_entity_id gcs_entry_headers.entity_id%type;
102: BEGIN
103:
104: l_entry_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
105: p_item_key,

Line 149: l_debug_info := 'Before calling Update GCS Entry Headers, item_key: ' || p_item_key || 'Submitter Name '|| l_submitter_name;

145: -- Set the Approval information on the Item Attributes
146: WF_ENGINE.SetItemAttrDate(
147: p_item_type, p_item_key, 'REQUEST_DATE', trunc(sysdate));
148:
149: l_debug_info := 'Before calling Update GCS Entry Headers, item_key: ' || p_item_key || 'Submitter Name '|| l_submitter_name;
150:
151: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
152: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
153: l_api_name,l_debug_info);

Line 159: UPDATE GCS_ENTRY_HEADERS

155:
156: --- By default adjustment is approved, and later if there are
157: -- approvers on the list then gets changed to IN_PROGRESS
158:
159: UPDATE GCS_ENTRY_HEADERS
160: SET approval_status_code = 'IN_PROGRESS'
161: WHERE entry_id = p_item_key;
162:
163: -- Create PDF file to be attached to Notification

Line 223: FROM GCS_ENTRY_HEADERS

219: , ENTRY_TYPE_CODE
220: , CATEGORY_CODE
221: , CREATED_BY
222: , WORKFLOW_KEY
223: FROM GCS_ENTRY_HEADERS
224: WHERE ENTRY_ID = p_entry_id;
225:
226: l_entry_id gcs_entry_headers.entry_id%type;
227: l_entry_name gcs_entry_headers.entry_name%type;

Line 226: l_entry_id gcs_entry_headers.entry_id%type;

222: , WORKFLOW_KEY
223: FROM GCS_ENTRY_HEADERS
224: WHERE ENTRY_ID = p_entry_id;
225:
226: l_entry_id gcs_entry_headers.entry_id%type;
227: l_entry_name gcs_entry_headers.entry_name%type;
228: l_hierarchy_id gcs_entry_headers.hierarchy_id%type;
229: l_entity_id gcs_entry_headers.entity_id%type;
230: l_currency_code gcs_entry_headers.currency_code%type;

Line 227: l_entry_name gcs_entry_headers.entry_name%type;

223: FROM GCS_ENTRY_HEADERS
224: WHERE ENTRY_ID = p_entry_id;
225:
226: l_entry_id gcs_entry_headers.entry_id%type;
227: l_entry_name gcs_entry_headers.entry_name%type;
228: l_hierarchy_id gcs_entry_headers.hierarchy_id%type;
229: l_entity_id gcs_entry_headers.entity_id%type;
230: l_currency_code gcs_entry_headers.currency_code%type;
231: l_balance_type_code gcs_entry_headers.balance_type_code%type;

Line 228: l_hierarchy_id gcs_entry_headers.hierarchy_id%type;

224: WHERE ENTRY_ID = p_entry_id;
225:
226: l_entry_id gcs_entry_headers.entry_id%type;
227: l_entry_name gcs_entry_headers.entry_name%type;
228: l_hierarchy_id gcs_entry_headers.hierarchy_id%type;
229: l_entity_id gcs_entry_headers.entity_id%type;
230: l_currency_code gcs_entry_headers.currency_code%type;
231: l_balance_type_code gcs_entry_headers.balance_type_code%type;
232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;

Line 229: l_entity_id gcs_entry_headers.entity_id%type;

225:
226: l_entry_id gcs_entry_headers.entry_id%type;
227: l_entry_name gcs_entry_headers.entry_name%type;
228: l_hierarchy_id gcs_entry_headers.hierarchy_id%type;
229: l_entity_id gcs_entry_headers.entity_id%type;
230: l_currency_code gcs_entry_headers.currency_code%type;
231: l_balance_type_code gcs_entry_headers.balance_type_code%type;
232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;
233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;

Line 230: l_currency_code gcs_entry_headers.currency_code%type;

226: l_entry_id gcs_entry_headers.entry_id%type;
227: l_entry_name gcs_entry_headers.entry_name%type;
228: l_hierarchy_id gcs_entry_headers.hierarchy_id%type;
229: l_entity_id gcs_entry_headers.entity_id%type;
230: l_currency_code gcs_entry_headers.currency_code%type;
231: l_balance_type_code gcs_entry_headers.balance_type_code%type;
232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;
233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;
234: l_description gcs_entry_headers.description%type;

Line 231: l_balance_type_code gcs_entry_headers.balance_type_code%type;

227: l_entry_name gcs_entry_headers.entry_name%type;
228: l_hierarchy_id gcs_entry_headers.hierarchy_id%type;
229: l_entity_id gcs_entry_headers.entity_id%type;
230: l_currency_code gcs_entry_headers.currency_code%type;
231: l_balance_type_code gcs_entry_headers.balance_type_code%type;
232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;
233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;
234: l_description gcs_entry_headers.description%type;
235: l_entry_type_code gcs_entry_headers.entry_type_code%type;

Line 232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;

228: l_hierarchy_id gcs_entry_headers.hierarchy_id%type;
229: l_entity_id gcs_entry_headers.entity_id%type;
230: l_currency_code gcs_entry_headers.currency_code%type;
231: l_balance_type_code gcs_entry_headers.balance_type_code%type;
232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;
233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;
234: l_description gcs_entry_headers.description%type;
235: l_entry_type_code gcs_entry_headers.entry_type_code%type;
236: l_category_code gcs_entry_headers.category_code%type;

Line 233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;

229: l_entity_id gcs_entry_headers.entity_id%type;
230: l_currency_code gcs_entry_headers.currency_code%type;
231: l_balance_type_code gcs_entry_headers.balance_type_code%type;
232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;
233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;
234: l_description gcs_entry_headers.description%type;
235: l_entry_type_code gcs_entry_headers.entry_type_code%type;
236: l_category_code gcs_entry_headers.category_code%type;
237: l_submitted_by gcs_entry_headers.created_by%type;

Line 234: l_description gcs_entry_headers.description%type;

230: l_currency_code gcs_entry_headers.currency_code%type;
231: l_balance_type_code gcs_entry_headers.balance_type_code%type;
232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;
233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;
234: l_description gcs_entry_headers.description%type;
235: l_entry_type_code gcs_entry_headers.entry_type_code%type;
236: l_category_code gcs_entry_headers.category_code%type;
237: l_submitted_by gcs_entry_headers.created_by%type;
238: l_itemkey VARCHAR2(80);

Line 235: l_entry_type_code gcs_entry_headers.entry_type_code%type;

231: l_balance_type_code gcs_entry_headers.balance_type_code%type;
232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;
233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;
234: l_description gcs_entry_headers.description%type;
235: l_entry_type_code gcs_entry_headers.entry_type_code%type;
236: l_category_code gcs_entry_headers.category_code%type;
237: l_submitted_by gcs_entry_headers.created_by%type;
238: l_itemkey VARCHAR2(80);
239:

Line 236: l_category_code gcs_entry_headers.category_code%type;

232: l_start_cal_period_id gcs_entry_headers.start_cal_period_id%type;
233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;
234: l_description gcs_entry_headers.description%type;
235: l_entry_type_code gcs_entry_headers.entry_type_code%type;
236: l_category_code gcs_entry_headers.category_code%type;
237: l_submitted_by gcs_entry_headers.created_by%type;
238: l_itemkey VARCHAR2(80);
239:
240: l_entity_name fem_entities_tl.entity_name%type;

Line 237: l_submitted_by gcs_entry_headers.created_by%type;

233: l_end_cal_period_id gcs_entry_headers.end_cal_period_id%type;
234: l_description gcs_entry_headers.description%type;
235: l_entry_type_code gcs_entry_headers.entry_type_code%type;
236: l_category_code gcs_entry_headers.category_code%type;
237: l_submitted_by gcs_entry_headers.created_by%type;
238: l_itemkey VARCHAR2(80);
239:
240: l_entity_name fem_entities_tl.entity_name%type;
241: l_hierarchy_name gcs_hierarchies_tl.hierarchy_name%type;

Line 384: UPDATE GCS_ENTRY_HEADERS

380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
381: l_api_name,l_debug_info);
382: END IF;
383:
384: UPDATE GCS_ENTRY_HEADERS
385: SET approval_status_code = 'IN_PROGRESS' ,
386: WORKFLOW_KEY = l_itemkey
387: WHERE entry_id = p_entry_id;
388:

Line 716: l_attachment := 'FND:entity=GCS_ENTRY_HEADERS'||'&'||'pk1name=ENTRY_ID'||'&'||'pk1value='||l_entry_id;

712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
713: l_api_name,l_debug_info);
714: END IF;
715:
716: l_attachment := 'FND:entity=GCS_ENTRY_HEADERS'||'&'||'pk1name=ENTRY_ID'||'&'||'pk1value='||l_entry_id;
717:
718: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'WFREGION', l_wf_region);
719: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, '#ATTACHMENTS', l_attachment);
720:

Line 1058: UPDATE GCS_ENTRY_HEADERS

1054: else
1055: l_status :='ERROR';
1056: end if;
1057:
1058: UPDATE GCS_ENTRY_HEADERS
1059: SET approval_status_code = l_status
1060: WHERE entry_id = l_entry_id;
1061:
1062: COMMIT;