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.

[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on INV_GLOBALS

Line 2603: and replaced the code with selection of COAs using the API - INV_GLOBALS.GET_LEDGER_INFO

2599:
2600: --Getting chart_of_accounts_id
2601:
2602: /* commented the selection of COA using LE - OU link which is obsoleted in R12
2603: and replaced the code with selection of COAs using the API - INV_GLOBALS.GET_LEDGER_INFO
2604: Bug No - 4336479
2605: BEGIN
2606: SELECT
2607: gsob.chart_of_accounts_id

Line 2629: Inv_globals.get_ledger_info(

2625: END;
2626: */
2627:
2628: BEGIN
2629: Inv_globals.get_ledger_info(
2630: x_return_status => lreturn_status,
2631: x_msg_data => lmsg_data ,
2632: p_context_type => 'Operating Unit Information',
2633: p_org_id => p_ship_organization_id,

Line 2648: and replaced the code with selection of COAs using the API - INV_GLOBALS.GET_LEDGER_INFO

2644:
2645:
2646: -- sell side
2647: /* commented the selection of COA using LE - OU link which is obsoleted in R12
2648: and replaced the code with selection of COAs using the API - INV_GLOBALS.GET_LEDGER_INFO
2649: Bug No - 4336479
2650: BEGIN
2651: select
2652: gsob.chart_of_accounts_id

Line 2673: Inv_globals.get_ledger_info(

2669: END;
2670: */
2671:
2672: BEGIN
2673: Inv_globals.get_ledger_info(
2674: x_return_status => lreturn_status,
2675: x_msg_data => lmsg_data ,
2676: p_context_type => 'Operating Unit Information',
2677: p_org_id => p_sell_organization_id,

Line 2992: x_transaction_type_id := INV_GLOBALS.G_TYPE_RETURN_TO_VENDOR;

2988: 'RETURN TO CUSTOMER',
2989: 'RETURN TO VENDOR') THEN
2990:
2991: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
2992: x_transaction_type_id := INV_GLOBALS.G_TYPE_RETURN_TO_VENDOR;
2993: x_transaction_action_id := INV_GLOBALS.G_ACTION_ISSUE;
2994: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
2995:
2996: ELSE

Line 2993: x_transaction_action_id := INV_GLOBALS.G_ACTION_ISSUE;

2989: 'RETURN TO VENDOR') THEN
2990:
2991: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
2992: x_transaction_type_id := INV_GLOBALS.G_TYPE_RETURN_TO_VENDOR;
2993: x_transaction_action_id := INV_GLOBALS.G_ACTION_ISSUE;
2994: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
2995:
2996: ELSE
2997:

Line 2994: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

2990:
2991: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
2992: x_transaction_type_id := INV_GLOBALS.G_TYPE_RETURN_TO_VENDOR;
2993: x_transaction_action_id := INV_GLOBALS.G_ACTION_ISSUE;
2994: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
2995:
2996: ELSE
2997:
2998: OPEN drop_ship_sources(l_po_header_id,l_po_line_id,l_po_line_location_id);

Line 3026: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;

3022:
3023: IF NOT l_external_drop_ship THEN
3024: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
3025: IF l_transaction_type = 'DELIVER' THEN
3026: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3027: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3028: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3029: ELSIF l_transaction_type = 'CORRECT' THEN
3030: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;

Line 3027: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;

3023: IF NOT l_external_drop_ship THEN
3024: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
3025: IF l_transaction_type = 'DELIVER' THEN
3026: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3027: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3028: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3029: ELSIF l_transaction_type = 'CORRECT' THEN
3030: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3031: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;

Line 3028: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3024: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
3025: IF l_transaction_type = 'DELIVER' THEN
3026: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3027: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3028: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3029: ELSIF l_transaction_type = 'CORRECT' THEN
3030: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3031: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3032: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

Line 3030: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;

3026: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3027: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3028: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3029: ELSIF l_transaction_type = 'CORRECT' THEN
3030: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3031: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3032: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3033: END IF;
3034: ELSE

Line 3031: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;

3027: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3028: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3029: ELSIF l_transaction_type = 'CORRECT' THEN
3030: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3031: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3032: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3033: END IF;
3034: ELSE
3035:

Line 3032: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3028: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3029: ELSIF l_transaction_type = 'CORRECT' THEN
3030: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3031: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3032: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3033: END IF;
3034: ELSE
3035:
3036: BEGIN

Line 3147: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT;

3143: --Drop ship logical
3144: x_dropship_type_code := G_LOGICAL_RECEIPT_FOR_DS;
3145: IF l_transaction_type = 'DELIVER' THEN
3146: x_header_id := l_txn_flow_header_id;
3147: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT;
3148: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;
3149: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3150: ELSIF l_transaction_type = 'CORRECT' THEN
3151: x_header_id := l_txn_flow_header_id;

Line 3148: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;

3144: x_dropship_type_code := G_LOGICAL_RECEIPT_FOR_DS;
3145: IF l_transaction_type = 'DELIVER' THEN
3146: x_header_id := l_txn_flow_header_id;
3147: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT;
3148: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;
3149: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3150: ELSIF l_transaction_type = 'CORRECT' THEN
3151: x_header_id := l_txn_flow_header_id;
3152: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;

Line 3149: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3145: IF l_transaction_type = 'DELIVER' THEN
3146: x_header_id := l_txn_flow_header_id;
3147: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT;
3148: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;
3149: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3150: ELSIF l_transaction_type = 'CORRECT' THEN
3151: x_header_id := l_txn_flow_header_id;
3152: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;
3153: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;

Line 3152: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;

3148: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;
3149: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3150: ELSIF l_transaction_type = 'CORRECT' THEN
3151: x_header_id := l_txn_flow_header_id;
3152: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;
3153: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;
3154: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3155: END IF;
3156: ELSE

Line 3153: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;

3149: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3150: ELSIF l_transaction_type = 'CORRECT' THEN
3151: x_header_id := l_txn_flow_header_id;
3152: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;
3153: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;
3154: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3155: END IF;
3156: ELSE
3157: --Drop ship Physical

Line 3154: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3150: ELSIF l_transaction_type = 'CORRECT' THEN
3151: x_header_id := l_txn_flow_header_id;
3152: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;
3153: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;
3154: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3155: END IF;
3156: ELSE
3157: --Drop ship Physical
3158: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_DS;

Line 3160: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;

3156: ELSE
3157: --Drop ship Physical
3158: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_DS;
3159: IF l_transaction_type = 'DELIVER' THEN
3160: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3161: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3162: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3163: ELSIF l_transaction_type = 'CORRECT' THEN
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;

Line 3161: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;

3157: --Drop ship Physical
3158: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_DS;
3159: IF l_transaction_type = 'DELIVER' THEN
3160: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3161: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3162: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3163: ELSIF l_transaction_type = 'CORRECT' THEN
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;

Line 3162: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3158: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_DS;
3159: IF l_transaction_type = 'DELIVER' THEN
3160: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3161: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3162: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3163: ELSIF l_transaction_type = 'CORRECT' THEN
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

Line 3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;

3160: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3161: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3162: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3163: ELSIF l_transaction_type = 'CORRECT' THEN
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3167: END IF;
3168: END IF;

Line 3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;

3161: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3162: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3163: ELSIF l_transaction_type = 'CORRECT' THEN
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3167: END IF;
3168: END IF;
3169:

Line 3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3162: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3163: ELSIF l_transaction_type = 'CORRECT' THEN
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3167: END IF;
3168: END IF;
3169:
3170: END IF;--NOT l_external_drop_ship

Line 3396: and replaced the code with selection of COAs using the API - INV_GLOBALS.GET_LEDGER_INFO

3392: -- Modified the message text set of books to ledger for making the message compatible with LE uptake project
3393: print_Debug('Get the ledgers', 'get_functional_currency_code');
3394:
3395: /* commented the selection of COA using LE - OU link which is obsoleted in R12
3396: and replaced the code with selection of COAs using the API - INV_GLOBALS.GET_LEDGER_INFO
3397: Bug No - 4336479
3398: BEGIN
3399: l_progress := 1;
3400: SELECT to_number(LEI.org_information1)

Line 3422: Inv_globals.get_ledger_info(

3418: END;
3419: */
3420: BEGIN
3421: l_progress := 1;
3422: Inv_globals.get_ledger_info(
3423: x_return_status => lreturn_status,
3424: x_msg_data => lmsg_data ,
3425: p_context_type => 'Operating Unit Information',
3426: p_org_id => p_org_id,