DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on CTO_CONFIG_ITEM_PK

Line 1: package body CTO_CONFIG_ITEM_PK as

1: package body CTO_CONFIG_ITEM_PK as
2: /* $Header: CTOCITMB.pls 120.19.12010000.2 2008/08/11 16:04:38 abhissri ship $ */
3:
4: /*----------------------------------------------------------------------------+
5: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA

Line 5332: oe_debug_pub.add ('Create_Item: ' || 'gWtStatus = '||CTO_CONFIG_ITEM_PK.gWtStatus|| ' and gVolStatus = '||CTO_CONFIG_ITEM_PK.gVolStatus,1);

5328: -- This is done to prevent calculation of upper level config's if lower level
5329: -- configs have errored out.
5330:
5331: IF PG_DEBUG <> 0 THEN
5332: oe_debug_pub.add ('Create_Item: ' || 'gWtStatus = '||CTO_CONFIG_ITEM_PK.gWtStatus|| ' and gVolStatus = '||CTO_CONFIG_ITEM_PK.gVolStatus,1);
5333: END IF;
5334:
5335: if CTO_CONFIG_ITEM_PK.gWtStatus = 0 or -- 0 means success
5336: CTO_CONFIG_ITEM_PK.gVolStatus = 0

Line 5335: if CTO_CONFIG_ITEM_PK.gWtStatus = 0 or -- 0 means success

5331: IF PG_DEBUG <> 0 THEN
5332: oe_debug_pub.add ('Create_Item: ' || 'gWtStatus = '||CTO_CONFIG_ITEM_PK.gWtStatus|| ' and gVolStatus = '||CTO_CONFIG_ITEM_PK.gVolStatus,1);
5333: END IF;
5334:
5335: if CTO_CONFIG_ITEM_PK.gWtStatus = 0 or -- 0 means success
5336: CTO_CONFIG_ITEM_PK.gVolStatus = 0
5337: then
5338:
5339: -- begin bugfix 1811007

Line 5336: CTO_CONFIG_ITEM_PK.gVolStatus = 0

5332: oe_debug_pub.add ('Create_Item: ' || 'gWtStatus = '||CTO_CONFIG_ITEM_PK.gWtStatus|| ' and gVolStatus = '||CTO_CONFIG_ITEM_PK.gVolStatus,1);
5333: END IF;
5334:
5335: if CTO_CONFIG_ITEM_PK.gWtStatus = 0 or -- 0 means success
5336: CTO_CONFIG_ITEM_PK.gVolStatus = 0
5337: then
5338:
5339: -- begin bugfix 1811007
5340:

Line 5530: end if; /* end check CTO_CONFIG_ITEM_PK.gWtStatus */

5526:
5527: -- end bugfix 2905835
5528:
5529: END;
5530: end if; /* end check CTO_CONFIG_ITEM_PK.gWtStatus */
5531:
5532: -- end bugfix 1811007
5533:
5534:

Line 5900: if CTO_CONFIG_ITEM_PK.gWtStatus = 0 then

5896:
5897: -- bugfix 2301167: Calculate the config's wt if the previous calculation of lower level config was
5898: -- successful. gWtStatus would be set to -1 if calculation was not successful.
5899:
5900: if CTO_CONFIG_ITEM_PK.gWtStatus = 0 then
5901:
5902: IF PG_DEBUG <> 0 THEN
5903: oe_debug_pub.add ('Create_Item: ' || '===>weight_uom = '||weight_uom,1);
5904: END IF;

Line 5927: CTO_CONFIG_ITEM_PK.gWtStatus := -1; -- -1 means error

5923: weight := 0;
5924:
5925: -- Also, we shouldn't calculate the wt for the top config since the lower level's config
5926: -- weight has been updated to 0
5927: CTO_CONFIG_ITEM_PK.gWtStatus := -1; -- -1 means error
5928: exit;
5929: end if;
5930: weight := weight + lweight;
5931:

Line 5945: if CTO_CONFIG_ITEM_PK.gVolStatus = 0 then

5941:
5942: -- bugfix 2301167: Calculate the config's wt if the previous calculation of lower level config was
5943: -- successful. gWtStatus would be set to -1 if calculation was not successful.
5944:
5945: if CTO_CONFIG_ITEM_PK.gVolStatus = 0 then
5946:
5947: IF PG_DEBUG <> 0 THEN
5948: oe_debug_pub.add ('Create_Item: ' || '===>volume_uom = '||volume_uom,1);
5949: END IF;

Line 5971: CTO_CONFIG_ITEM_PK.gVolStatus := -1; -- -1 means error

5967: volume := 0;
5968:
5969: -- Also, we shouldn't calculate the vol for the top config since the lower level's config
5970: -- volume has been updated to 0
5971: CTO_CONFIG_ITEM_PK.gVolStatus := -1; -- -1 means error
5972: exit;
5973: end if;
5974: volume := volume + lvolume;
5975:

Line 9865: end CTO_CONFIG_ITEM_PK;

9861:
9862:
9863:
9864:
9865: end CTO_CONFIG_ITEM_PK;
9866: