[Home] [Help]
439: END IF;
440: --
441: SELECT Bom_Explosion_Temp_S.NextVal
442: INTO l_group_id
443: FROM sys.dual;
444:
445: Bompxinq.Exploder_Userexit(
446: grp_id => l_group_id,
447: org_id => p_organization_id,
8011: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
8012:
8013: SELECT MOD(p_instance_rec.object_version_number,l_full_dump_frequency)
8014: INTO l_mod_value
8015: FROM dual;
8016:
8017: -- Start of modifications for Bug#2547034 on 09/20/02 - rtalluri
8018: BEGIN
8019: SELECT instance_history_id
12510: --
12511: Begin
12512: select CSI_II_FORWARD_SYNC_TEMP_S.CURRVAL
12513: into l_current_val
12514: FROM DUAL;
12515: Exception
12516: when others then
12517: l_current_val := -9999999;
12518: End;
15111:
15112:
15113: select mod(p_instance_rec.object_version_number,l_full_dump_frequency)
15114: into l_mod_value
15115: from dual;
15116:
15117: -- Start of modification for Bug#2547034 on 09/20/02 - rtalluri
15118: BEGIN
15119: SELECT instance_history_id
19849: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
19850:
19851: SELECT MOD(p_instance_rec.object_version_number,l_full_dump_frequency)
19852: INTO l_mod_value
19853: FROM dual;
19854:
19855:
19856: IF (l_mod_value = 0) THEN
19857: -- If the mod value is 0 then dump all the columns both changed and unchanged
21142: END IF;
21143:
21144: SELECT MOD(l_instance_rec.object_version_number,l_full_dump_frequency)
21145: INTO l_mod_value
21146: FROM dual;
21147:
21148: -- Added for the bug 6788183
21149: BEGIN
21150: SELECT instance_history_id
24124: END IF;
24125: --
24126: select mod(l_object_version_number,l_full_dump_frequency)
24127: into l_mod_value
24128: from dual;
24129:
24130: -- Start of modification for Bug#2547034 on 09/20/02 - rtalluri
24131: BEGIN
24132: SELECT version_label_history_id
25239: END IF;
25240:
25241: select mod(l_object_version_number,l_full_dump_frequency)
25242: into l_mod_value
25243: from dual;
25244:
25245: IF (l_mod_value = 0) THEN
25246: -- If the mod value is 0 then dump all the columns both changed and unchanged
25247: -- changed columns have old and new values while the unchanged values have old and new values
29963: END IF;
29964: --
29965: SELECT Bom_Explosion_Temp_S.NextVal
29966: INTO l_group_id
29967: FROM sys.dual;
29968: --
29969: Bompxinq.Exploder_Userexit
29970: (
29971: grp_id => l_group_id,
35816:
35817:
35818: SELECT csi_item_instance_locks_s.NEXTVAL
35819: INTO l_lock_id
35820: FROM SYS.dual;
35821:
35822: IF px_config_tbl.COUNT > 0
35823: THEN
35824: FOR i IN px_config_tbl.FIRST .. px_config_tbl.LAST