APPS.GMF_PERIODCLOSE_PVT dependencies on ORG_ACCT_PERIODS

Line 75: org_acct_periods oacp

71: oacp.schedule_close_date,
72: oacp.open_flag
73: FROM
74: mtl_parameters mp,
75: org_acct_periods oacp
76: WHERE
77: mp.organization_id = p_organization_id AND
78: mp.organization_id = oacp.organization_id AND
79: oacp.acct_period_id = p_acct_period_id

Line 90: l_period_name org_acct_periods.period_name%TYPE;

86: l_legal_entity_id NUMBER(15);
87:
88: l_organization_code VARCHAR2(3);
89: l_org_process_flag VARCHAR2(1);
90: l_period_name org_acct_periods.period_name%TYPE;
91: l_le_period_close_date DATE;
92: l_period_close_date DATE;
93: l_per_open_flag VARCHAR2(1);
94:

Line 216: UPDATE org_acct_periods

212:
213: Log_Msg(C_LOG_FILE,'Inventory Balance compilation completed.');
214:
215: /* All done, update period status to Closed */
216: UPDATE org_acct_periods
217: SET
218: open_flag = 'N',
219: summarized_flag = 'Y'
220: WHERE

Line 695: UPDATE org_acct_periods

691: )
692: IS
693:
694: BEGIN
695: UPDATE org_acct_periods
696: SET
697: open_flag = 'Y',
698: summarized_flag = NULL
699: WHERE

Line 797: FROM ORG_ACCT_PERIODS

793: /* get the period to close*/
794: CURSOR cur_period_to_close(p_org_id IN NUMBER, p_year IN NUMBER, p_period IN NUMBER, p_period_set_name in varchar2)
795: IS
796: SELECT acct_period_id, period_start_date start_date, schedule_close_date close_date, period_name
797: FROM ORG_ACCT_PERIODS
798: WHERE organization_id = p_org_id
799: and period_set_name = p_period_Set_name
800: and period_year = p_year
801: and period_num = p_period

Line 1022: UPDATE org_acct_periods

1018: GOTO period_close;
1019: END IF;
1020:
1021: /* you are here if all the checks are successful*/
1022: UPDATE org_acct_periods
1023: SET
1024: open_flag = 'P',
1025: period_close_date = trunc(sysdate),
1026: last_update_date = trunc(sysdate),

Line 1038: Log_Msg(C_LOG_FILE,' Failed Updating org_acct_periods to pending.');

1034: organization_id = l_organization_id AND
1035: period_set_name = l_period_set_name;
1036:
1037: IF (SQL%NOTFOUND) THEN
1038: Log_Msg(C_LOG_FILE,' Failed Updating org_acct_periods to pending.');
1039: RAISE NO_DATA_FOUND;
1040: END IF;
1041:
1042: END IF;

Line 1109: UPDATE org_acct_periods

1105: Log_Msg(C_LOG_FILE,' Inventory Balance compilation completed.');
1106:
1107: /* All done, update period status to Closed */
1108: IF l_final_close = 1 THEN
1109: UPDATE org_acct_periods
1110: SET
1111: open_flag = 'N',
1112: summarized_flag = 'Y'
1113: WHERE

Line 1118: Log_Msg(C_LOG_FILE,' Failed Updating org_acct_periods to closed');

1114: organization_id = l_organization_id AND
1115: acct_period_id = l_acct_period_id;
1116:
1117: IF (SQL%NOTFOUND) THEN
1118: Log_Msg(C_LOG_FILE,' Failed Updating org_acct_periods to closed');
1119: RAISE NO_DATA_FOUND;
1120: END IF;
1121:
1122: END IF;