DBA Data[Home] [Help]

APPS.PJM_MASS_TRANSFER_WF dependencies on PJM_MASS_TRANSFER_PUB

Line 157: AND X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_ONE_ITEM

153: SELECT concatenated_segments , description
154: FROM mtl_system_items_b_kfv
155: WHERE organization_id = X_Organization_ID
156: AND inventory_item_id = X_Item_ID
157: AND X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_ONE_ITEM
158: UNION ALL
159: SELECT concatenated_segments , description
160: FROM mtl_categories_b_kfv
161: WHERE category_id = X_Category_ID

Line 162: AND X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_CATEGORY;

158: UNION ALL
159: SELECT concatenated_segments , description
160: FROM mtl_categories_b_kfv
161: WHERE category_id = X_Category_ID
162: AND X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_CATEGORY;
163:
164: icrec ic%rowtype;
165:
166: ItemCat VARCHAR2(2000);

Line 301: IF ( crec.transfer_mode in ( PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_ONE_ITEM

297:
298: --
299: -- Get Displayable info for item / category
300: --
301: IF ( crec.transfer_mode in ( PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_ONE_ITEM
302: , PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_CATEGORY ) ) THEN
303:
304: OPEN ic ( crec.transfer_mode , crec.organization_id , crec.inventory_item_id , crec.category_id );
305: FETCH ic INTO icrec;

Line 302: , PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_CATEGORY ) ) THEN

298: --
299: -- Get Displayable info for item / category
300: --
301: IF ( crec.transfer_mode in ( PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_ONE_ITEM
302: , PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_CATEGORY ) ) THEN
303:
304: OPEN ic ( crec.transfer_mode , crec.organization_id , crec.inventory_item_id , crec.category_id );
305: FETCH ic INTO icrec;
306: CLOSE ic;

Line 573: PJM_MASS_TRANSFER_PUB.Mass_Transfer

569: IF ( FuncMode = 'RUN' ) THEN
570:
571: Apps_Initialize( itemtype => ItemType , itemkey => ItemKey );
572:
573: PJM_MASS_TRANSFER_PUB.Mass_Transfer
574: ( P_api_version => 1.0
575: , P_init_msg_list => FND_API.G_TRUE
576: , P_commit => FND_API.G_FALSE
577: , X_Return_Status => Return_Status