13:
14: -- Definition of all the entities
15: TYPE Burden_Header_Rec_Type IS RECORD
16: (
17: organization_id cm_brdn_dtl.organization_id%TYPE ,
18: organization_code mtl_parameters.organization_code%TYPE ,
19: inventory_item_id mtl_item_flexfields.inventory_item_id%TYPE ,
20: item_number mtl_item_flexfields.item_number%TYPE ,
21: period_id cm_brdn_dtl.period_id%TYPE ,
17: organization_id cm_brdn_dtl.organization_id%TYPE ,
18: organization_code mtl_parameters.organization_code%TYPE ,
19: inventory_item_id mtl_item_flexfields.inventory_item_id%TYPE ,
20: item_number mtl_item_flexfields.item_number%TYPE ,
21: period_id cm_brdn_dtl.period_id%TYPE ,
22: calendar_code cm_brdn_dtl.calendar_code%TYPE ,
23: period_code cm_brdn_dtl.period_code%TYPE ,
24: cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
25: cost_mthd_code cm_brdn_dtl.cost_mthd_code%TYPE ,
18: organization_code mtl_parameters.organization_code%TYPE ,
19: inventory_item_id mtl_item_flexfields.inventory_item_id%TYPE ,
20: item_number mtl_item_flexfields.item_number%TYPE ,
21: period_id cm_brdn_dtl.period_id%TYPE ,
22: calendar_code cm_brdn_dtl.calendar_code%TYPE ,
23: period_code cm_brdn_dtl.period_code%TYPE ,
24: cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
25: cost_mthd_code cm_brdn_dtl.cost_mthd_code%TYPE ,
26: user_name fnd_user.user_name%TYPE
19: inventory_item_id mtl_item_flexfields.inventory_item_id%TYPE ,
20: item_number mtl_item_flexfields.item_number%TYPE ,
21: period_id cm_brdn_dtl.period_id%TYPE ,
22: calendar_code cm_brdn_dtl.calendar_code%TYPE ,
23: period_code cm_brdn_dtl.period_code%TYPE ,
24: cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
25: cost_mthd_code cm_brdn_dtl.cost_mthd_code%TYPE ,
26: user_name fnd_user.user_name%TYPE
27: );
20: item_number mtl_item_flexfields.item_number%TYPE ,
21: period_id cm_brdn_dtl.period_id%TYPE ,
22: calendar_code cm_brdn_dtl.calendar_code%TYPE ,
23: period_code cm_brdn_dtl.period_code%TYPE ,
24: cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
25: cost_mthd_code cm_brdn_dtl.cost_mthd_code%TYPE ,
26: user_name fnd_user.user_name%TYPE
27: );
28:
21: period_id cm_brdn_dtl.period_id%TYPE ,
22: calendar_code cm_brdn_dtl.calendar_code%TYPE ,
23: period_code cm_brdn_dtl.period_code%TYPE ,
24: cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
25: cost_mthd_code cm_brdn_dtl.cost_mthd_code%TYPE ,
26: user_name fnd_user.user_name%TYPE
27: );
28:
29: TYPE Burden_Dtl_Rec_Type IS RECORD
34: cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ,
35: cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE ,
36: burden_usage NUMBER ,
37: item_qty NUMBER ,
38: item_uom cm_brdn_dtl.item_uom%TYPE ,
39: burden_qty NUMBER ,
40: burden_uom cm_brdn_dtl.burden_uom%TYPE ,
41: burden_factor NUMBER ,
42: delete_mark cm_brdn_dtl.delete_mark%TYPE := 0
36: burden_usage NUMBER ,
37: item_qty NUMBER ,
38: item_uom cm_brdn_dtl.item_uom%TYPE ,
39: burden_qty NUMBER ,
40: burden_uom cm_brdn_dtl.burden_uom%TYPE ,
41: burden_factor NUMBER ,
42: delete_mark cm_brdn_dtl.delete_mark%TYPE := 0
43: );
44:
38: item_uom cm_brdn_dtl.item_uom%TYPE ,
39: burden_qty NUMBER ,
40: burden_uom cm_brdn_dtl.burden_uom%TYPE ,
41: burden_factor NUMBER ,
42: delete_mark cm_brdn_dtl.delete_mark%TYPE := 0
43: );
44:
45: TYPE Burden_Dtl_Tbl_Type IS TABLE OF Burden_Dtl_Rec_Type
46: INDEX BY BINARY_INTEGER;
48: TYPE Burdenline_Ids_Rec_Type IS RECORD
49: (
50: resources cm_rsrc_dtl.resources%TYPE ,
51: cost_cmpntcls_id NUMBER ,
52: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE ,
53: burdenline_id NUMBER
54: );
55:
56: TYPE Burdenline_Ids_Tbl_Type IS TABLE OF Burdenline_Ids_Rec_Type