DBA Data[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 3004: x_transaction_type_id := INV_GLOBALS.G_TYPE_RETURN_TO_VENDOR;

3000: when NO_DATA_FOUND then
3001: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
3002: end;
3003:
3004: x_transaction_type_id := INV_GLOBALS.G_TYPE_RETURN_TO_VENDOR;
3005: x_transaction_action_id := INV_GLOBALS.G_ACTION_ISSUE;
3006: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3007:
3008: ELSE

Line 3005: x_transaction_action_id := INV_GLOBALS.G_ACTION_ISSUE;

3001: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
3002: end;
3003:
3004: x_transaction_type_id := INV_GLOBALS.G_TYPE_RETURN_TO_VENDOR;
3005: x_transaction_action_id := INV_GLOBALS.G_ACTION_ISSUE;
3006: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3007:
3008: ELSE
3009:

Line 3006: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3002: end;
3003:
3004: x_transaction_type_id := INV_GLOBALS.G_TYPE_RETURN_TO_VENDOR;
3005: x_transaction_action_id := INV_GLOBALS.G_ACTION_ISSUE;
3006: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3007:
3008: ELSE
3009:
3010: OPEN drop_ship_sources(l_po_header_id,l_po_line_id,l_po_line_location_id);

Line 3038: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;

3034:
3035: IF NOT l_external_drop_ship THEN
3036: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
3037: IF l_transaction_type = 'DELIVER' THEN
3038: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3039: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3040: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3041: ELSIF l_transaction_type = 'CORRECT' THEN
3042: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;

Line 3039: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;

3035: IF NOT l_external_drop_ship THEN
3036: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
3037: IF l_transaction_type = 'DELIVER' THEN
3038: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3039: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3040: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3041: ELSIF l_transaction_type = 'CORRECT' THEN
3042: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3043: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;

Line 3040: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3036: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;
3037: IF l_transaction_type = 'DELIVER' THEN
3038: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3039: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3040: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3041: ELSIF l_transaction_type = 'CORRECT' THEN
3042: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3043: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3044: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

Line 3042: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;

3038: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3039: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3040: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3041: ELSIF l_transaction_type = 'CORRECT' THEN
3042: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3043: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3044: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3045: END IF;
3046: ELSE

Line 3043: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;

3039: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3040: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3041: ELSIF l_transaction_type = 'CORRECT' THEN
3042: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3043: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3044: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3045: END IF;
3046: ELSE
3047:

Line 3044: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3040: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3041: ELSIF l_transaction_type = 'CORRECT' THEN
3042: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3043: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3044: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3045: END IF;
3046: ELSE
3047:
3048: BEGIN

Line 3159: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT;

3155: --Drop ship logical
3156: x_dropship_type_code := G_LOGICAL_RECEIPT_FOR_DS;
3157: IF l_transaction_type = 'DELIVER' THEN
3158: x_header_id := l_txn_flow_header_id;
3159: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT;
3160: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;
3161: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3162: ELSIF l_transaction_type = 'CORRECT' THEN
3163: x_header_id := l_txn_flow_header_id;

Line 3160: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;

3156: x_dropship_type_code := G_LOGICAL_RECEIPT_FOR_DS;
3157: IF l_transaction_type = 'DELIVER' THEN
3158: x_header_id := l_txn_flow_header_id;
3159: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT;
3160: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;
3161: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3162: ELSIF l_transaction_type = 'CORRECT' THEN
3163: x_header_id := l_txn_flow_header_id;
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;

Line 3161: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3157: IF l_transaction_type = 'DELIVER' THEN
3158: x_header_id := l_txn_flow_header_id;
3159: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT;
3160: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;
3161: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3162: ELSIF l_transaction_type = 'CORRECT' THEN
3163: x_header_id := l_txn_flow_header_id;
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;

Line 3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;

3160: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALRECEIPT;
3161: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3162: ELSIF l_transaction_type = 'CORRECT' THEN
3163: x_header_id := l_txn_flow_header_id;
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;
3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3167: END IF;
3168: ELSE

Line 3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;

3161: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3162: ELSIF l_transaction_type = 'CORRECT' THEN
3163: x_header_id := l_txn_flow_header_id;
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;
3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3167: END IF;
3168: ELSE
3169: --Drop ship Physical

Line 3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3162: ELSIF l_transaction_type = 'CORRECT' THEN
3163: x_header_id := l_txn_flow_header_id;
3164: x_transaction_type_id := INV_GLOBALS.G_TYPE_LOGL_PO_RECEIPT_ADJ;
3165: x_transaction_action_id := INV_GLOBALS.G_ACTION_LOGICALDELADJ;
3166: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3167: END IF;
3168: ELSE
3169: --Drop ship Physical
3170: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_DS;

Line 3172: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;

3168: ELSE
3169: --Drop ship Physical
3170: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_DS;
3171: IF l_transaction_type = 'DELIVER' THEN
3172: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3173: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3174: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3175: ELSIF l_transaction_type = 'CORRECT' THEN
3176: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;

Line 3173: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;

3169: --Drop ship Physical
3170: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_DS;
3171: IF l_transaction_type = 'DELIVER' THEN
3172: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3173: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3174: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3175: ELSIF l_transaction_type = 'CORRECT' THEN
3176: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3177: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;

Line 3174: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3170: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_DS;
3171: IF l_transaction_type = 'DELIVER' THEN
3172: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3173: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3174: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3175: ELSIF l_transaction_type = 'CORRECT' THEN
3176: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3177: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3178: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

Line 3176: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;

3172: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RECEIPT;
3173: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3174: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3175: ELSIF l_transaction_type = 'CORRECT' THEN
3176: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3177: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3178: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3179: END IF;
3180: END IF;

Line 3177: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;

3173: x_transaction_action_id := INV_GLOBALS.G_ACTION_RECEIPT;
3174: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3175: ELSIF l_transaction_type = 'CORRECT' THEN
3176: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3177: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3178: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3179: END IF;
3180: END IF;
3181:

Line 3178: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;

3174: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3175: ELSIF l_transaction_type = 'CORRECT' THEN
3176: x_transaction_type_id := INV_GLOBALS.G_TYPE_PO_RCPT_ADJ;
3177: x_transaction_action_id := INV_GLOBALS.G_ACTION_DELIVERYADJ;
3178: x_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER;
3179: END IF;
3180: END IF;
3181:
3182: END IF;--NOT l_external_drop_ship

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

3404: -- Modified the message text set of books to ledger for making the message compatible with LE uptake project
3405: print_Debug('Get the ledgers', 'get_functional_currency_code');
3406:
3407: /* commented the selection of COA using LE - OU link which is obsoleted in R12
3408: and replaced the code with selection of COAs using the API - INV_GLOBALS.GET_LEDGER_INFO
3409: Bug No - 4336479
3410: BEGIN
3411: l_progress := 1;
3412: SELECT to_number(LEI.org_information1)

Line 3434: Inv_globals.get_ledger_info(

3430: END;
3431: */
3432: BEGIN
3433: l_progress := 1;
3434: Inv_globals.get_ledger_info(
3435: x_return_status => lreturn_status,
3436: x_msg_data => lmsg_data ,
3437: p_context_type => 'Operating Unit Information',
3438: p_org_id => p_org_id,