APPS.CZ_LOGIC_GEN dependencies on CZ_LCE_LOAD_SPECS

Line 7976: INSERT INTO cz_lce_load_specs

7972: VALUES
7973: (nHeaderId, VersionString, GenHeader, v_tPsNodeId(i), LOGIC_NET_TYPE_MANDATORY,
7974: thisProjectId, v_NodeId(i), 1, FLAG_PENDING);
7975:
7976: INSERT INTO cz_lce_load_specs
7977: (attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id,
7978: model_id, net_type, deleted_flag)
7979: VALUES
7980: (v_NodeId(i), nHeaderId, v_NodeId(i), v_tPsNodeId(i), thisProjectId,

Line 9110: INSERT INTO cz_lce_load_specs

9106: --The following statement populates the new ALIAS_NAME column introduced as a fix
9107: --for the bug #2214414. The column is populated with C_ for
9108: --connector conditions and with NULL for other conditions (optional components).
9109:
9110: INSERT INTO cz_lce_load_specs
9111: (attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id,
9112: model_id, net_type, deleted_flag, alias_name)
9113: VALUES
9114: (MaxDepthId, nHeaderId, nAux, v_tPsNodeId(v_IndexByNodeId(MaxDepthId)),

Line 9694: INSERT INTO cz_lce_load_specs

9690: VALUES
9691: (nHeaderId, VersionString, GenHeader, inComponentId, LOGIC_NET_TYPE_MANDATORY,
9692: thisProjectId, thisComponentExplId, 1, FLAG_PENDING);
9693:
9694: INSERT INTO cz_lce_load_specs
9695: (attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id,
9696: model_id, net_type, deleted_flag)
9697: VALUES
9698: (thisComponentExplId, nHeaderId, thisComponentExplId, inComponentId,

Line 9934: INSERT INTO cz_lce_load_specs

9930: thisProjectId, thisComponentExplId, 1, FLAG_PENDING);
9931:
9932: --Insert the structure load conditions record for this component.
9933:
9934: INSERT INTO cz_lce_load_specs
9935: (attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id,
9936: model_id, net_type, deleted_flag)
9937: VALUES
9938: (thisComponentExplId, nStructureHeaderId, thisComponentExplId, inComponentId,

Line 11099: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED

11095: UPDATE cz_lce_headers SET deleted_flag = FLAG_DELETED
11096: WHERE lce_header_id = OldHeaders(i);
11097:
11098: FORALL i IN 1..OldHeaders.COUNT
11099: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED
11100: WHERE lce_header_id = OldHeaders(i);
11101:
11102: FORALL i IN 1..NewHeaders.COUNT
11103: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED

Line 11107: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED

11103: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED
11104: WHERE lce_header_id = NewHeaders(i);
11105:
11106: FORALL i IN 1..NewHeaders.COUNT
11107: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11108: WHERE lce_header_id = NewHeaders(i);
11109:
11110: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11111:

Line 11129: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED

11125: UPDATE cz_lce_headers SET deleted_flag = FLAG_DELETED
11126: WHERE lce_header_id = NewHeaders(i);
11127:
11128: FORALL i IN 1..NewHeaders.COUNT
11129: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED
11130: WHERE lce_header_id = NewHeaders(i);
11131:
11132: IF(OldHeaders.COUNT > 0)THEN
11133:

Line 11139: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED

11135: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED
11136: WHERE lce_header_id = OldHeaders(i);
11137:
11138: FORALL i IN 1..OldHeaders.COUNT
11139: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11140: WHERE lce_header_id = OldHeaders(i);
11141: END IF;
11142:
11143: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);