[Home] [Help]
733:
734: --before locking the arg, select to see if its initialized already by another thread
735: SELECT initialized_success_flag, valid_value_flag, canonical_value, source_type, source_text, source_final_text
736: INTO l_initialized_success_flag, l_valid_value_flag, l_canonical_value, l_source_type, l_source_text, l_source_final_text
737: FROM fnd_oam_dscram_args_b
738: WHERE arg_id = px_arg.arg_id;
739:
740: -- if init success already determined, update our local state variables and return
741: IF l_initialized_success_flag IS NOT NULL THEN
756:
757: -- if we got here, we'll probably be updating the arg so lock it and make sure we still need to update it
758: SELECT initialized_success_flag, valid_value_flag, canonical_value, source_type, source_text, source_where_clause, source_final_text
759: INTO l_initialized_success_flag, l_valid_value_flag, l_canonical_value, l_source_type, l_source_text, l_source_where_clause, l_source_final_text
760: FROM fnd_oam_dscram_args_b
761: WHERE arg_id = px_arg.arg_id
762: FOR UPDATE;
763:
764: --check again after the locking select to see if somebody else has already done the init
823: END IF;
824:
825: --Finally, if we ended up initializing the arg, write out that new state
826: IF px_arg.initialized_success_flag IS NOT NULL THEN
827: UPDATE fnd_oam_dscram_args_b
828: SET initialized_success_flag = px_arg.initialized_success_flag,
829: source_final_text = l_source_final_text,
830: last_updated_by = fnd_global.user_id,
831: last_update_login = fnd_global.user_id,
836: --For constants, we bend the rules and write them even if it's not writable because otherwise get must incur the cost of messing
837: --with the source_text.
838: IF (px_arg.valid_value_flag IS NOT NULL AND IS_WRITABLE(px_arg)) THEN
839: fnd_oam_debug.log(1, l_ctxt, 'Pre-emptively writing the arg value');
840: UPDATE fnd_oam_dscram_args_b
841: SET valid_value_flag = px_arg.valid_value_flag,
842: canonical_value = px_arg.canonical_value
843: WHERE arg_id = px_arg.arg_id;
844: END IF;
857: EXCEPTION
858: WHEN INIT_FAILED THEN
859: --x_return_* already set, only raised after locking select
860: BEGIN
861: UPDATE fnd_oam_dscram_args_b
862: SET initialized_success_flag = FND_API.G_FALSE,
863: last_updated_by = fnd_global.user_id,
864: last_update_login = fnd_global.user_id,
865: last_update_date = SYSDATE
951: x_return_msg := '';
952:
953: IF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE THEN
954: --update the main args_b row
955: UPDATE fnd_oam_dscram_args_b
956: SET valid_value_flag = px_arg.valid_value_flag,
957: canonical_value = px_arg.canonical_value,
958: last_updated_by = fnd_global.user_id,
959: last_update_login = fnd_global.user_id,
1164: IF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE THEN
1165: --query the main args_b row
1166: SELECT valid_value_flag, canonical_value
1167: INTO l_valid_value_flag, l_canonical_value
1168: FROM fnd_oam_dscram_args_b
1169: WHERE arg_id = px_arg.arg_id;
1170: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Once: first query valid_value_flag: '||l_valid_value_flag);
1171: ELSIF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_WORKER THEN
1172: --Needed in the case of restart to get the value we may have comitted for this worker
1228: --Known Issue: when the run is in a non-normal mode, write-once args will be written by each worker because the batch
1229: --is never comitted. In the normal mode, the first successful batch is the only one to write the arg value.
1230: SELECT valid_value_flag, canonical_value
1231: INTO l_valid_value_flag, l_canonical_value
1232: FROM fnd_oam_dscram_args_b
1233: WHERE arg_id = px_arg.arg_id;
1234: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Once, locking query valid_value_flag: '||l_valid_value_flag);
1235:
1236: --re-check the valid value flag
1802: PRAGMA AUTONOMOUS_TRANSACTION;
1803:
1804: l_ctxt VARCHAR2(60) := PKG_NAME||'RESET_INITIALIZED_AUTONOMOUSLY';
1805: BEGIN
1806: UPDATE fnd_oam_dscram_args_b
1807: SET initialized_success_flag = NULL,
1808: last_updated_by = fnd_global.user_id,
1809: last_update_login = fnd_global.user_id,
1810: last_update_date = SYSDATE
1998: -- put both readable and writable args in the context
1999: SELECT arg_id, arg_name, initialized_success_flag, allow_override_source_flag, binding_enabled_flag, permissions, write_policy, datatype, valid_value_flag, canonical_value
2000: BULK COLLECT INTO l_arg_ids, l_arg_names, l_initialized_success_flags, l_allow_override_source_flags, l_binding_enabled_flags, l_permissions,
2001: l_write_policies, l_datatypes, l_valid_value_flags, l_canonical_values
2002: FROM fnd_oam_dscram_args_b
2003: WHERE ((parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_GLOBAL) OR
2004: ((parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RUN) AND
2005: (parent_id = p_run_id)))
2006: AND enabled_flag = FND_API.G_TRUE
2099: --and bind the args in different orders.
2100: SELECT arg_id, arg_name, initialized_success_flag, allow_override_source_flag, binding_enabled_flag, permissions, write_policy, datatype, valid_value_flag, canonical_value
2101: BULK COLLECT INTO l_arg_ids, l_arg_names, l_initialized_success_flags, l_allow_override_source_flags, l_binding_enabled_flags, l_permissions,
2102: l_write_policies, l_datatypes, l_valid_value_flags, l_canonical_values
2103: FROM fnd_oam_dscram_args_b
2104: WHERE parent_type = p_parent_type
2105: AND parent_id = p_parent_id
2106: AND enabled_flag = FND_API.G_TRUE
2107: ORDER BY arg_id ASC;
2666:
2667: delete from FND_OAM_DSCRAM_ARGS_TL T
2668: where not exists
2669: (select NULL
2670: from FND_OAM_DSCRAM_ARGS_B B
2671: where B.ARG_ID = T.ARG_ID
2672: );
2673:
2674: update FND_OAM_DSCRAM_ARGS_TL T set (