DBA Data[Home] [Help]

APPS.GMF_BURDENDETAILS_PUB dependencies on CM_BRDN_DTL

Line 342: --| Function : Updates Burden Details based on the input in CM_BRDN_DTL |

338: --Start of comments
339: --+========================================================================+
340: --| API Name : Update_Burden_Details |
341: --| TYPE : Public |
342: --| Function : Updates Burden Details based on the input in CM_BRDN_DTL |
343: --| Pre-reqa : None. |
344: --| Parameters : |
345: --| IN : |
346: --| p_api_version IN NUMBER - Required |

Line 557: --| Function : Deletes Burden Details based on the input from CM_BRDN_DTL|

553: --Start of comments
554: --+========================================================================+
555: --| API Name : Delete_Burden_Details |
556: --| TYPE : Public |
557: --| Function : Deletes Burden Details based on the input from CM_BRDN_DTL|
558: --| Pre-reqa : None. |
559: --| Parameters : |
560: --| IN : |
561: --| p_api_version IN NUMBER - Required |

Line 774: --| Function : Retrieve Burden Details based on the input from CM_BRDN_DTL|

770: --Start of comments
771: --+========================================================================+
772: --| API Name : Get_Burden_Details |
773: --| TYPE : Public |
774: --| Function : Retrieve Burden Details based on the input from CM_BRDN_DTL|
775: --| Pre-reqa : None. |
776: --| Parameters : |
777: --| IN : |
778: --| p_api_version IN NUMBER - Required |

Line 824: l_act_item_uom cm_brdn_dtl.item_uom%TYPE ;

820: l_count NUMBER(10) ;
821: l_data VARCHAR2(2000) ;
822:
823: l_header_rec Burden_Header_Rec_Type ;
824: l_act_item_uom cm_brdn_dtl.item_uom%TYPE ;
825: l_period_status cm_cldr_dtl.period_status%TYPE ;
826: l_user_id fnd_user.user_id%TYPE ;
827: l_lc_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
828:

Line 1294: l_burdenline_id cm_brdn_dtl.burdenline_id%TYPE ;

1290: l_resource_uom cr_rsrc_mst.std_usage_uom%TYPE ;
1291: l_burden_uom_class mtl_units_of_measure.uom_class%TYPE ;
1292: l_resource_uom_class mtl_units_of_measure.uom_class%TYPE ;
1293:
1294: l_burdenline_id cm_brdn_dtl.burdenline_id%TYPE ;
1295: l_burden_factor cm_brdn_dtl.burden_factor%TYPE ;
1296:
1297: -- Bug 2681243
1298: l_resources cm_brdn_dtl.resources%TYPE ;

Line 1295: l_burden_factor cm_brdn_dtl.burden_factor%TYPE ;

1291: l_burden_uom_class mtl_units_of_measure.uom_class%TYPE ;
1292: l_resource_uom_class mtl_units_of_measure.uom_class%TYPE ;
1293:
1294: l_burdenline_id cm_brdn_dtl.burdenline_id%TYPE ;
1295: l_burden_factor cm_brdn_dtl.burden_factor%TYPE ;
1296:
1297: -- Bug 2681243
1298: l_resources cm_brdn_dtl.resources%TYPE ;
1299: l_burden_qty cm_brdn_dtl.burden_qty%TYPE ;

Line 1298: l_resources cm_brdn_dtl.resources%TYPE ;

1294: l_burdenline_id cm_brdn_dtl.burdenline_id%TYPE ;
1295: l_burden_factor cm_brdn_dtl.burden_factor%TYPE ;
1296:
1297: -- Bug 2681243
1298: l_resources cm_brdn_dtl.resources%TYPE ;
1299: l_burden_qty cm_brdn_dtl.burden_qty%TYPE ;
1300: l_burden_usage cm_brdn_dtl.burden_usage%TYPE ;
1301: l_burden_uom cm_brdn_dtl.burden_uom%TYPE ;
1302: l_item_qty cm_brdn_dtl.item_qty%TYPE ;

Line 1299: l_burden_qty cm_brdn_dtl.burden_qty%TYPE ;

1295: l_burden_factor cm_brdn_dtl.burden_factor%TYPE ;
1296:
1297: -- Bug 2681243
1298: l_resources cm_brdn_dtl.resources%TYPE ;
1299: l_burden_qty cm_brdn_dtl.burden_qty%TYPE ;
1300: l_burden_usage cm_brdn_dtl.burden_usage%TYPE ;
1301: l_burden_uom cm_brdn_dtl.burden_uom%TYPE ;
1302: l_item_qty cm_brdn_dtl.item_qty%TYPE ;
1303: l_item_uom cm_brdn_dtl.item_uom%TYPE ;

Line 1300: l_burden_usage cm_brdn_dtl.burden_usage%TYPE ;

1296:
1297: -- Bug 2681243
1298: l_resources cm_brdn_dtl.resources%TYPE ;
1299: l_burden_qty cm_brdn_dtl.burden_qty%TYPE ;
1300: l_burden_usage cm_brdn_dtl.burden_usage%TYPE ;
1301: l_burden_uom cm_brdn_dtl.burden_uom%TYPE ;
1302: l_item_qty cm_brdn_dtl.item_qty%TYPE ;
1303: l_item_uom cm_brdn_dtl.item_uom%TYPE ;
1304: l_lc_cost_type_id cm_mthd_mst.cost_type_id%TYPE;

Line 1301: l_burden_uom cm_brdn_dtl.burden_uom%TYPE ;

1297: -- Bug 2681243
1298: l_resources cm_brdn_dtl.resources%TYPE ;
1299: l_burden_qty cm_brdn_dtl.burden_qty%TYPE ;
1300: l_burden_usage cm_brdn_dtl.burden_usage%TYPE ;
1301: l_burden_uom cm_brdn_dtl.burden_uom%TYPE ;
1302: l_item_qty cm_brdn_dtl.item_qty%TYPE ;
1303: l_item_uom cm_brdn_dtl.item_uom%TYPE ;
1304: l_lc_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
1305:

Line 1302: l_item_qty cm_brdn_dtl.item_qty%TYPE ;

1298: l_resources cm_brdn_dtl.resources%TYPE ;
1299: l_burden_qty cm_brdn_dtl.burden_qty%TYPE ;
1300: l_burden_usage cm_brdn_dtl.burden_usage%TYPE ;
1301: l_burden_uom cm_brdn_dtl.burden_uom%TYPE ;
1302: l_item_qty cm_brdn_dtl.item_qty%TYPE ;
1303: l_item_uom cm_brdn_dtl.item_uom%TYPE ;
1304: l_lc_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
1305:
1306: l_converted_burden_qty NUMBER ;

Line 1303: l_item_uom cm_brdn_dtl.item_uom%TYPE ;

1299: l_burden_qty cm_brdn_dtl.burden_qty%TYPE ;
1300: l_burden_usage cm_brdn_dtl.burden_usage%TYPE ;
1301: l_burden_uom cm_brdn_dtl.burden_uom%TYPE ;
1302: l_item_qty cm_brdn_dtl.item_qty%TYPE ;
1303: l_item_uom cm_brdn_dtl.item_uom%TYPE ;
1304: l_lc_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
1305:
1306: l_converted_burden_qty NUMBER ;
1307: l_converted_item_qty NUMBER ;

Line 1705: FROM cm_brdn_dtl

1701: --
1702: BEGIN
1703: SELECT resources, burden_qty, burden_usage, burden_uom, item_qty, item_uom
1704: INTO l_resources, l_burden_qty, l_burden_usage, l_burden_uom, l_item_qty, l_item_uom
1705: FROM cm_brdn_dtl
1706: WHERE burdenline_id = l_burdenline_id;
1707:
1708: EXCEPTION
1709: WHEN NO_DATA_FOUND THEN

Line 1875: cm_brdn_dtl

1871: BEGIN
1872: SELECT resources, burden_qty, burden_usage, burden_uom, item_qty, item_uom
1873: INTO l_resources, l_burden_qty, l_burden_usage, l_burden_uom, l_item_qty, l_item_uom
1874: FROM
1875: cm_brdn_dtl
1876: WHERE
1877: organization_id = x_header_rec.organization_id
1878: AND inventory_item_id = x_header_rec.inventory_item_id
1879: AND period_id = x_header_rec.period_id