[Home] [Help]
276: and period_type = x_accounted_period_type
277: order by period_year, period_num;
278: CURSOR get_config_status IS
279: select completion_status_code
280: from gl_ledger_configurations
281: where configuration_id = x_configuration_id;
282: BEGIN
283: IF p_commit = fnd_api.g_true THEN
284: SAVEPOINT complete_workorder;
1194: IF ( (x_current_allow_intercom_flag = 'N')
1195: AND (x_allow_intercompany_post_flag = 'Y')) THEN
1196: --SELECT acctg_environment_code
1197: -- INTO x_acctg_environment_code
1198: -- FROM gl_ledger_configurations
1199: -- WHERE configuration_id = x_configuration_id;
1200: -- bug fix 3175231 insert the CE row in config details
1201: --IF ( (x_acctg_environment_code = 'EXCLUSIVE')
1202: -- OR ( (x_acctg_environment_code = 'SHARED')
1400:
1401: BEGIN
1402: SELECT completion_status_code
1403: INTO x_completion_status
1404: FROM gl_ledger_configurations
1405: WHERE configuration_id = x_configuration_id;
1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: x_completion_status := NULL;
1549: x_last_update_login => x_last_update_login);
1550: END IF;
1551:
1552: IF(x_ledger_category_code = 'PRIMARY') THEN
1553: update gl_ledger_configurations
1554: set name = x_name
1555: where configuration_id =
1556: (select configuration_id
1557: from gl_ledger_config_details
3533: AND segment_value_type_code = 'S'
3534: AND rownum<2;
3535: CURSOR get_complete_status IS
3536: select completion_status_code
3537: from gl_ledger_configurations
3538: where configuration_id =
3539: (select configuration_id
3540: from gl_ledger_config_details
3541: where object_id = x_le_id
3960: PROCEDURE set_status_complete(x_object_type VARCHAR2,
3961: x_object_id IN NUMBER) IS
3962: BEGIN
3963: IF(x_object_type = 'CONFIGURATION') THEN
3964: update gl_ledger_configurations
3965: set completion_status_code = 'CONFIRMED'
3966: where configuration_id = x_object_id;
3967:
3968: update gl_ledgers