APPS.GMF_PERIODCLOSE_PVT dependencies on ORG_ACCT_PERIODS

Line 80: org_acct_periods oacp

76: oacp.schedule_close_date,
77: oacp.open_flag
78: FROM
79: mtl_parameters mp,
80: org_acct_periods oacp
81: WHERE
82: mp.organization_id = p_organization_id AND
83: mp.organization_id = oacp.organization_id AND
84: oacp.acct_period_id = p_acct_period_id

Line 95: l_period_name org_acct_periods.period_name%TYPE;

91: l_legal_entity_id NUMBER(15);
92:
93: l_organization_code VARCHAR2(3);
94: l_org_process_flag VARCHAR2(1);
95: l_period_name org_acct_periods.period_name%TYPE;
96: l_le_period_close_date DATE;
97: l_period_close_date DATE;
98: l_per_open_flag VARCHAR2(1);
99:

Line 231: UPDATE org_acct_periods

227:
228: Log_Msg(C_LOG_FILE,'Inventory Balance compilation completed.');
229:
230: /* All done, update period status to Closed */
231: UPDATE org_acct_periods
232: SET
233: open_flag = 'N',
234: summarized_flag = 'Y'
235: WHERE

Line 724: UPDATE org_acct_periods

720: )
721: IS
722:
723: BEGIN
724: UPDATE org_acct_periods
725: SET
726: open_flag = 'Y',
727: summarized_flag = NULL
728: WHERE

Line 828: FROM ORG_ACCT_PERIODS

824: /* get the period to close*/
825: CURSOR cur_period_to_close(p_org_id IN NUMBER, p_year IN NUMBER, p_period IN NUMBER, p_period_set_name in varchar2)
826: IS
827: SELECT acct_period_id, period_start_date start_date, schedule_close_date close_date, period_name
828: FROM ORG_ACCT_PERIODS
829: WHERE organization_id = p_org_id
830: and period_set_name = p_period_Set_name
831: and period_year = p_year
832: and period_num = p_period

Line 1079: UPDATE org_acct_periods

1075: GOTO period_close;
1076: END IF;
1077:
1078: /* you are here if all the checks are successful*/
1079: UPDATE org_acct_periods
1080: SET
1081: open_flag = 'P',
1082: period_close_date = trunc(sysdate),
1083: last_update_date = trunc(sysdate),

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

1091: organization_id = l_organization_id AND
1092: period_set_name = l_period_set_name;
1093:
1094: IF (SQL%NOTFOUND) THEN
1095: Log_Msg(C_LOG_FILE,' Failed Updating org_acct_periods to pending.');
1096: RAISE NO_DATA_FOUND;
1097: END IF;
1098:
1099: END IF;

Line 1178: UPDATE org_acct_periods

1174: Log_Msg(C_LOG_FILE,' Inventory Balance compilation completed.');
1175:
1176: /* All done, update period status to Closed */
1177: IF l_final_close = 1 THEN
1178: UPDATE org_acct_periods
1179: SET
1180: open_flag = 'N',
1181: summarized_flag = 'Y'
1182: WHERE

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

1183: organization_id = l_organization_id AND
1184: acct_period_id = l_acct_period_id;
1185:
1186: IF (SQL%NOTFOUND) THEN
1187: Log_Msg(C_LOG_FILE,' Failed Updating org_acct_periods to closed');
1188: RAISE NO_DATA_FOUND;
1189: END IF;
1190:
1191: END IF;