APPS.GMF_SUBLEDGER_PKG dependencies on GL_SUBR_STA

Line 223: l_up_reference_no gl_subr_sta.reference_no%TYPE;

219: l_up_temp_start_date DATE;
220: l_up_temp_end_date DATE;
221: l_up_posting_start_date DATE;
222: l_up_posting_end_date DATE;
223: l_up_reference_no gl_subr_sta.reference_no%TYPE;
224: l_up_request_id gl_subr_sta.request_id%TYPE;
225: l_up_sch_count NUMBER(15);
226: l_date_range_secs NUMBER;
227: l_req_date_range NUMBER;

Line 224: l_up_request_id gl_subr_sta.request_id%TYPE;

220: l_up_temp_end_date DATE;
221: l_up_posting_start_date DATE;
222: l_up_posting_end_date DATE;
223: l_up_reference_no gl_subr_sta.reference_no%TYPE;
224: l_up_request_id gl_subr_sta.request_id%TYPE;
225: l_up_sch_count NUMBER(15);
226: l_date_range_secs NUMBER;
227: l_req_date_range NUMBER;
228: l_req_start_date DATE := NULL;

Line 303: FROM gl_subr_sta

299: ,cp_post_pm VARCHAR2
300: )
301: IS
302: SELECT reference_no, request_id, count(*) over()
303: FROM gl_subr_sta
304: WHERE legal_entity_id = cp_le_id
305: AND ledger_id = cp_ledger_id
306: AND cost_type_id = cp_cost_type_id
307: AND fiscal_year = cp_gl_fiscal_year

Line 328: FROM gl_subr_sta

324: ,cp_posting_end_date DATE
325: )
326: IS
327: SELECT reference_no, request_id, count(*) over()
328: FROM gl_subr_sta
329: WHERE legal_entity_id = cp_le_id
330: AND ledger_id = cp_ledger_id
331: AND cost_type_id = cp_cost_type_id
332: AND fiscal_year = cp_gl_fiscal_year

Line 628: gmf_util.log(l_procedure_name || ': inserting the control records into gl_subr_sta');

624: RAISE e_validation_failed;
625: END IF;
626:
627: /* insert the control record */
628: gmf_util.log(l_procedure_name || ': inserting the control records into gl_subr_sta');
629: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
630: THEN
631: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
632: END IF;

Line 776: UPDATE gl_subr_sta

772: THEN
773: l_msg_text := FND_MESSAGE.get;
774: RAISE e_req_submit_error;
775: ELSE
776: UPDATE gl_subr_sta
777: SET request_id = l_conc_id
778: WHERE reference_no = l_subledger_ref_no;
779:
780: COMMIT;

Line 913: UPDATE gl_subr_sta

909: THEN
910: l_msg_text := FND_MESSAGE.get;
911: RAISE e_req_submit_error;
912: ELSE
913: UPDATE gl_subr_sta
914: SET request_id = l_conc_id
915: WHERE reference_no = l_subledger_ref_no;
916:
917: COMMIT;

Line 994: UPDATE gl_subr_sta

990: THEN
991: l_msg_text := FND_MESSAGE.get;
992: RAISE e_req_submit_error;
993: ELSE
994: UPDATE gl_subr_sta
995: SET request_id = l_conc_id
996: WHERE reference_no = l_subledger_ref_no;
997:
998: COMMIT;

Line 1581: FROM gl_subr_sta

1577: cp_post_om VARCHAR2, cp_post_pm VARCHAR2,
1578: cp_post_pur VARCHAR2 )
1579: IS
1580: SELECT reference_no, request_id, count(*) over()
1581: FROM gl_subr_sta
1582: WHERE legal_entity_id = cp_le_id
1583: AND ledger_id = cp_ledger_id
1584: AND cost_type_id = cp_cost_type_id
1585: AND fiscal_year = cp_gl_fiscal_year

Line 1610: FROM gl_subr_sta

1606: cp_posting_end_date DATE
1607: )
1608: IS
1609: SELECT reference_no, request_id, count(*) over()
1610: FROM gl_subr_sta
1611: WHERE legal_entity_id = cp_le_id
1612: AND ledger_id = cp_ledger_id
1613: AND cost_type_id = cp_cost_type_id
1614: AND fiscal_year = cp_gl_fiscal_year

Line 1626: l_reference_no gl_subr_sta.reference_no%TYPE;

1622: (cp_posting_end_date between period_start_date and period_end_date)
1623: )
1624: ;
1625:
1626: l_reference_no gl_subr_sta.reference_no%TYPE;
1627: l_request_id gl_subr_sta.request_id%TYPE;
1628: l_sch_count NUMBER(15);
1629: l_subledger_ref_no NUMBER(15) := NULL;
1630:

Line 1627: l_request_id gl_subr_sta.request_id%TYPE;

1623: )
1624: ;
1625:
1626: l_reference_no gl_subr_sta.reference_no%TYPE;
1627: l_request_id gl_subr_sta.request_id%TYPE;
1628: l_sch_count NUMBER(15);
1629: l_subledger_ref_no NUMBER(15) := NULL;
1630:
1631: e_insert_error EXCEPTION;

Line 1748: INSERT INTO gl_subr_sta

1744: -- B 7203807
1745: Select gem5_reference_no_s.NEXTVAL INTO l_subledger_ref_no From Dual;
1746:
1747: /* insert the control record */
1748: INSERT INTO gl_subr_sta
1749: (
1750: co_code,
1751: current_state,
1752: start_time,

Line 1918: gmf_util.log(l_procedure_name || ': ' || sql%rowcount || ' control record inserted into gl_subr_sta table. ' ||

1914: x_subledger_ref_no := l_subledger_ref_no;
1915:
1916: x_retstatus := 'S';
1917:
1918: gmf_util.log(l_procedure_name || ': ' || sql%rowcount || ' control record inserted into gl_subr_sta table. ' ||
1919: ' end of procedure');
1920: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1921: THEN
1922: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);