DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_LCE_LOAD_SPECS

Line 7991: INSERT INTO cz_lce_load_specs

7987: VALUES
7988: (nHeaderId, VersionString, GenHeader, v_tPsNodeId(i), LOGIC_NET_TYPE_MANDATORY,
7989: thisProjectId, v_NodeId(i), 1, FLAG_PENDING);
7990:
7991: INSERT INTO cz_lce_load_specs
7992: (attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id,
7993: model_id, net_type, deleted_flag)
7994: VALUES
7995: (v_NodeId(i), nHeaderId, v_NodeId(i), v_tPsNodeId(i), thisProjectId,

Line 9138: INSERT INTO cz_lce_load_specs

9134: --The following statement populates the new ALIAS_NAME column introduced as a fix
9135: --for the bug #2214414. The column is populated with C_ for
9136: --connector conditions and with NULL for other conditions (optional components).
9137:
9138: INSERT INTO cz_lce_load_specs
9139: (attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id,
9140: model_id, net_type, deleted_flag, alias_name)
9141: VALUES
9142: (MaxDepthId, nHeaderId, nAux, v_tPsNodeId(v_IndexByNodeId(MaxDepthId)),

Line 9726: INSERT INTO cz_lce_load_specs

9722: VALUES
9723: (nHeaderId, VersionString, GenHeader, inComponentId, LOGIC_NET_TYPE_MANDATORY,
9724: thisProjectId, thisComponentExplId, 1, FLAG_PENDING);
9725:
9726: INSERT INTO cz_lce_load_specs
9727: (attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id,
9728: model_id, net_type, deleted_flag)
9729: VALUES
9730: (thisComponentExplId, nHeaderId, thisComponentExplId, inComponentId,

Line 9966: INSERT INTO cz_lce_load_specs

9962: thisProjectId, thisComponentExplId, 1, FLAG_PENDING);
9963:
9964: --Insert the structure load conditions record for this component.
9965:
9966: INSERT INTO cz_lce_load_specs
9967: (attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id,
9968: model_id, net_type, deleted_flag)
9969: VALUES
9970: (thisComponentExplId, nStructureHeaderId, thisComponentExplId, inComponentId,

Line 11174: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED

11170: UPDATE cz_lce_headers SET deleted_flag = FLAG_DELETED
11171: WHERE lce_header_id = OldHeaders(i);
11172:
11173: FORALL i IN 1..OldHeaders.COUNT
11174: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED
11175: WHERE lce_header_id = OldHeaders(i);
11176:
11177: FORALL i IN 1..NewHeaders.COUNT
11178: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED

Line 11182: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED

11178: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED
11179: WHERE lce_header_id = NewHeaders(i);
11180:
11181: FORALL i IN 1..NewHeaders.COUNT
11182: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11183: WHERE lce_header_id = NewHeaders(i);
11184:
11185: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11186:

Line 11204: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED

11200: UPDATE cz_lce_headers SET deleted_flag = FLAG_DELETED
11201: WHERE lce_header_id = NewHeaders(i);
11202:
11203: FORALL i IN 1..NewHeaders.COUNT
11204: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED
11205: WHERE lce_header_id = NewHeaders(i);
11206:
11207: IF(OldHeaders.COUNT > 0)THEN
11208:

Line 11214: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED

11210: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED
11211: WHERE lce_header_id = OldHeaders(i);
11212:
11213: FORALL i IN 1..OldHeaders.COUNT
11214: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11215: WHERE lce_header_id = OldHeaders(i);
11216: END IF;
11217:
11218: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);