eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UPGRADE dependencies on CZ_CONFIG_ITEMS

Line 3022: var_bom_sort cz_config_items.bom_sort_order%TYPE;

3018: v_config_item_id INTEGER;
3019: startRec PLS_INTEGER;
3020: endRec PLS_INTEGER;
3021: BatchSize INTEGER:=p_batch_size;
3022: var_bom_sort cz_config_items.bom_sort_order%TYPE;
3023: xERROR BOOLEAN:=FALSE;
3024:
3025: TYPE tConfigItemId IS TABLE OF cz_config_items.config_item_id%TYPE INDEX BY BINARY_INTEGER;
3026: TYPE tConfigHdrId IS TABLE OF cz_config_items.config_hdr_id%TYPE INDEX BY BINARY_INTEGER;

Line 3025: TYPE tConfigItemId IS TABLE OF cz_config_items.config_item_id%TYPE INDEX BY BINARY_INTEGER;

3021: BatchSize INTEGER:=p_batch_size;
3022: var_bom_sort cz_config_items.bom_sort_order%TYPE;
3023: xERROR BOOLEAN:=FALSE;
3024:
3025: TYPE tConfigItemId IS TABLE OF cz_config_items.config_item_id%TYPE INDEX BY BINARY_INTEGER;
3026: TYPE tConfigHdrId IS TABLE OF cz_config_items.config_hdr_id%TYPE INDEX BY BINARY_INTEGER;
3027: TYPE tConfigRevNbr IS TABLE OF cz_config_items.config_rev_nbr%TYPE INDEX BY BINARY_INTEGER;
3028: TYPE tBomSortOrder IS TABLE OF cz_config_items.bom_sort_order%TYPE INDEX BY BINARY_INTEGER;
3029:

Line 3026: TYPE tConfigHdrId IS TABLE OF cz_config_items.config_hdr_id%TYPE INDEX BY BINARY_INTEGER;

3022: var_bom_sort cz_config_items.bom_sort_order%TYPE;
3023: xERROR BOOLEAN:=FALSE;
3024:
3025: TYPE tConfigItemId IS TABLE OF cz_config_items.config_item_id%TYPE INDEX BY BINARY_INTEGER;
3026: TYPE tConfigHdrId IS TABLE OF cz_config_items.config_hdr_id%TYPE INDEX BY BINARY_INTEGER;
3027: TYPE tConfigRevNbr IS TABLE OF cz_config_items.config_rev_nbr%TYPE INDEX BY BINARY_INTEGER;
3028: TYPE tBomSortOrder IS TABLE OF cz_config_items.bom_sort_order%TYPE INDEX BY BINARY_INTEGER;
3029:
3030: tabConfigItemId tConfigItemId;

Line 3027: TYPE tConfigRevNbr IS TABLE OF cz_config_items.config_rev_nbr%TYPE INDEX BY BINARY_INTEGER;

3023: xERROR BOOLEAN:=FALSE;
3024:
3025: TYPE tConfigItemId IS TABLE OF cz_config_items.config_item_id%TYPE INDEX BY BINARY_INTEGER;
3026: TYPE tConfigHdrId IS TABLE OF cz_config_items.config_hdr_id%TYPE INDEX BY BINARY_INTEGER;
3027: TYPE tConfigRevNbr IS TABLE OF cz_config_items.config_rev_nbr%TYPE INDEX BY BINARY_INTEGER;
3028: TYPE tBomSortOrder IS TABLE OF cz_config_items.bom_sort_order%TYPE INDEX BY BINARY_INTEGER;
3029:
3030: tabConfigItemId tConfigItemId;
3031: tabConfigHdrId tConfigHdrId;

Line 3028: TYPE tBomSortOrder IS TABLE OF cz_config_items.bom_sort_order%TYPE INDEX BY BINARY_INTEGER;

3024:
3025: TYPE tConfigItemId IS TABLE OF cz_config_items.config_item_id%TYPE INDEX BY BINARY_INTEGER;
3026: TYPE tConfigHdrId IS TABLE OF cz_config_items.config_hdr_id%TYPE INDEX BY BINARY_INTEGER;
3027: TYPE tConfigRevNbr IS TABLE OF cz_config_items.config_rev_nbr%TYPE INDEX BY BINARY_INTEGER;
3028: TYPE tBomSortOrder IS TABLE OF cz_config_items.bom_sort_order%TYPE INDEX BY BINARY_INTEGER;
3029:
3030: tabConfigItemId tConfigItemId;
3031: tabConfigHdrId tConfigHdrId;
3032: tabConfigRevNbr tConfigRevNbr;

Line 3055: FROM cz_config_items

3051: sequenceNbr PLS_INTEGER := 1;
3052:
3053: BEGIN
3054: FOR i IN (SELECT config_item_id
3055: FROM cz_config_items
3056: WHERE parent_config_item_id = p_config_item_id
3057: AND config_hdr_id = p_config_hdr_id
3058: AND config_rev_nbr = p_config_rev_nbr
3059: AND (ps_node_id IS NULL OR ps_node_id < 0))

Line 3105: UPDATE cz_config_items

3101: endRec := startRec + BatchSize;
3102: IF(endRec > globalIndex)THEN endRec := globalIndex; END IF;
3103:
3104: FORALL i IN startRec..endRec
3105: UPDATE cz_config_items
3106: SET bom_sort_order = tabBomSortOrder(i)
3107: WHERE config_item_id = tabConfigItemId(i)
3108: AND config_hdr_id = tabConfigHdrId(i)
3109: AND config_rev_nbr = tabConfigRevNbr(i)