[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,
7796: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
7797:
7798: SELECT MOD(p_instance_rec.object_version_number,l_full_dump_frequency)
7799: INTO l_mod_value
7800: FROM dual;
7801:
7802: -- Start of modifications for Bug#2547034 on 09/20/02 - rtalluri
7803: BEGIN
7804: SELECT instance_history_id
12169: --
12170: Begin
12171: select CSI_II_FORWARD_SYNC_TEMP_S.CURRVAL
12172: into l_current_val
12173: FROM DUAL;
12174: Exception
12175: when others then
12176: l_current_val := -9999999;
12177: End;
14655:
14656:
14657: select mod(p_instance_rec.object_version_number,l_full_dump_frequency)
14658: into l_mod_value
14659: from dual;
14660:
14661: -- Start of modification for Bug#2547034 on 09/20/02 - rtalluri
14662: BEGIN
14663: SELECT instance_history_id
19352: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
19353:
19354: SELECT MOD(p_instance_rec.object_version_number,l_full_dump_frequency)
19355: INTO l_mod_value
19356: FROM dual;
19357:
19358:
19359: IF (l_mod_value = 0) THEN
19360: -- If the mod value is 0 then dump all the columns both changed and unchanged
20605: END IF;
20606:
20607: SELECT MOD(l_instance_rec.object_version_number,l_full_dump_frequency)
20608: INTO l_mod_value
20609: FROM dual;
20610:
20611: -- Added for the bug 6788183
20612: BEGIN
20613: SELECT instance_history_id
23567: END IF;
23568: --
23569: select mod(l_object_version_number,l_full_dump_frequency)
23570: into l_mod_value
23571: from dual;
23572:
23573: -- Start of modification for Bug#2547034 on 09/20/02 - rtalluri
23574: BEGIN
23575: SELECT version_label_history_id
24678: END IF;
24679:
24680: select mod(l_object_version_number,l_full_dump_frequency)
24681: into l_mod_value
24682: from dual;
24683:
24684: IF (l_mod_value = 0) THEN
24685: -- If the mod value is 0 then dump all the columns both changed and unchanged
24686: -- changed columns have old and new values while the unchanged values have old and new values
29372: END IF;
29373: --
29374: SELECT Bom_Explosion_Temp_S.NextVal
29375: INTO l_group_id
29376: FROM sys.dual;
29377: --
29378: Bompxinq.Exploder_Userexit
29379: (
29380: grp_id => l_group_id,
35159:
35160:
35161: SELECT csi_item_instance_locks_s.NEXTVAL
35162: INTO l_lock_id
35163: FROM SYS.dual;
35164:
35165: IF px_config_tbl.COUNT > 0
35166: THEN
35167: FOR i IN px_config_tbl.FIRST .. px_config_tbl.LAST