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.

APPS.PA_ACTIONS_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 86: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

82: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
83: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
84: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
85: ,p_debug_mode IN VARCHAR2 :='N'
86: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
87: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
88: ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
89: ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
90: ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()

Line 238: PA_INTERFACE_UTILS_PUB.get_messages

234: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
235: END IF;
236:
237: IF l_msg_count = 1 THEN
238: PA_INTERFACE_UTILS_PUB.get_messages
239: (p_encoded => FND_API.G_TRUE,
240: p_msg_index => 1,
241: p_msg_count => l_msg_count,
242: p_msg_data => l_msg_data,

Line 334: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

330: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
331: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
332: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
333: ,p_debug_mode IN VARCHAR2 :='N'
334: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
335: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
336: ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
337: ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
338: ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()

Line 479: PA_INTERFACE_UTILS_PUB.get_messages

475: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
476: END IF;
477:
478: IF l_msg_count = 1 THEN
479: PA_INTERFACE_UTILS_PUB.get_messages
480: (p_encoded => FND_API.G_TRUE,
481: p_msg_index => 1,
482: p_msg_count => l_msg_count,
483: p_msg_data => l_msg_data,

Line 548: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

544: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
545: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
546: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
547: ,p_debug_mode IN VARCHAR2 :='N'
548: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
549: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
550: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
551: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
552: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

Line 632: PA_INTERFACE_UTILS_PUB.get_messages

628: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
629: END IF;
630:
631: IF l_msg_count = 1 THEN
632: PA_INTERFACE_UTILS_PUB.get_messages
633: (p_encoded => FND_API.G_TRUE,
634: p_msg_index => 1,
635: p_msg_count => l_msg_count,
636: p_msg_data => l_msg_data,

Line 729: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

725: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
726: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
727: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
728: ,p_debug_mode IN VARCHAR2 :='N'
729: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
730: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
731: ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
732: ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
733: ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()

Line 1354: PA_INTERFACE_UTILS_PUB.get_messages

1350: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1351: END IF;
1352:
1353: IF l_msg_count = 1 THEN
1354: PA_INTERFACE_UTILS_PUB.get_messages
1355: (p_encoded => FND_API.G_TRUE,
1356: p_msg_index => 1,
1357: p_msg_count => l_msg_count,
1358: p_msg_data => l_msg_data,

Line 1437: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1433: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1434: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1435: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1436: ,p_debug_mode IN VARCHAR2 :='N'
1437: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1438: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1439: ,p_completed_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE()
1440: ,p_completion_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
1441: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()

Line 2107: IF p_carrying_out_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

2103: Pa_Debug.WRITE(g_module_name, 'token values proj ['||l_Project_Number||'] deliverable ['||l_deliverable_Number||']',l_debug_level3);
2104: END IF;
2105:
2106: -- Validate Carrying Out Org Id - valid value
2107: IF p_carrying_out_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2108: l_carrying_out_org_id := NULL;
2109: ELSE
2110: l_carrying_out_org_id := p_carrying_out_org_id;
2111: END IF;

Line 2156: IF p_action_owner_id_tbl(i_act) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

2152: j_act := p_action_owner_id_tbl.first();
2153:
2154: WHILE i_act is not null LOOP
2155:
2156: IF p_action_owner_id_tbl(i_act) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2157: l_action_owner_id := NULL;
2158: ELSE
2159: l_action_owner_id := p_action_owner_id_tbl(i_act);
2160: END IF;

Line 2205: IF (p_function_code_tbl(i_act) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2201: END IF;
2202: END IF;
2203:
2204: -- validate function code
2205: IF (p_function_code_tbl(i_act) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2206: OR p_function_code_tbl(i_act) = NULL )THEN
2207: l_function_code := NULL;
2208: ELSE
2209: l_function_code := p_function_code_tbl(i_act);

Line 2325: PA_INTERFACE_UTILS_PUB.get_messages

2321: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2322: END IF;
2323:
2324: IF l_msg_count = 1 THEN
2325: PA_INTERFACE_UTILS_PUB.get_messages
2326: (p_encoded => FND_API.G_TRUE,
2327: p_msg_index => 1,
2328: p_msg_count => l_msg_count,
2329: p_msg_data => l_msg_data,

Line 2385: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2381: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2382: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2383: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2384: ,p_debug_mode IN VARCHAR2 :='N'
2385: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2386: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
2387: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
2388: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2389: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

Line 2534: PA_INTERFACE_UTILS_PUB.get_messages

2530: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2531: END IF;
2532:
2533: IF l_msg_count = 1 THEN
2534: PA_INTERFACE_UTILS_PUB.get_messages
2535: (p_encoded => FND_API.G_TRUE,
2536: p_msg_index => 1,
2537: p_msg_count => l_msg_count,
2538: p_msg_data => l_msg_data,

Line 2606: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2602: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2603: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2604: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2605: ,p_debug_mode IN VARCHAR2 :='N'
2606: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2607: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
2608: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
2609: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
2610: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE

Line 2730: PA_INTERFACE_UTILS_PUB.get_messages

2726: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2727: END IF;
2728:
2729: IF l_msg_count = 1 THEN
2730: PA_INTERFACE_UTILS_PUB.get_messages
2731: (p_encoded => FND_API.G_TRUE,
2732: p_msg_index => 1,
2733: p_msg_count => l_msg_count,
2734: p_msg_data => l_msg_data,

Line 2786: IF ( p_action_in_rec.action_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2782: IS
2783: BEGIN
2784:
2785: -- common parameters for both shipping and procurement actions
2786: IF ( p_action_in_rec.action_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2787: AND p_action_in_rec.action_name IS NOT NULL) THEN
2788: RETURN 'N';
2789: END IF;
2790: IF ( p_action_in_rec.financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2790: IF ( p_action_in_rec.financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2786: IF ( p_action_in_rec.action_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2787: AND p_action_in_rec.action_name IS NOT NULL) THEN
2788: RETURN 'N';
2789: END IF;
2790: IF ( p_action_in_rec.financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2791: AND p_action_in_rec.financial_task_id IS NOT NULL) THEN
2792: RETURN 'N';
2793: END IF;
2794: IF ( p_action_in_rec.financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2794: IF ( p_action_in_rec.financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2790: IF ( p_action_in_rec.financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2791: AND p_action_in_rec.financial_task_id IS NOT NULL) THEN
2792: RETURN 'N';
2793: END IF;
2794: IF ( p_action_in_rec.financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2795: AND p_action_in_rec.financial_task_reference IS NOT NULL) THEN
2796: RETURN 'N';
2797: END IF;
2798: -- OKE procurement parameters

Line 2801: IF ( p_action_in_rec.destination_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2797: END IF;
2798: -- OKE procurement parameters
2799: IF ( p_function_code = g_procurement) THEN
2800:
2801: IF ( p_action_in_rec.destination_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2802: AND p_action_in_rec.destination_type_code IS NOT NULL) THEN
2803: RETURN 'N';
2804: END IF;
2805: IF ( p_action_in_rec.po_need_by_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2805: IF ( p_action_in_rec.po_need_by_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2801: IF ( p_action_in_rec.destination_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2802: AND p_action_in_rec.destination_type_code IS NOT NULL) THEN
2803: RETURN 'N';
2804: END IF;
2805: IF ( p_action_in_rec.po_need_by_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2806: AND p_action_in_rec.po_need_by_date IS NOT NULL) THEN
2807: RETURN 'N';
2808: END IF;
2809: IF ( p_action_in_rec.receiving_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2809: IF ( p_action_in_rec.receiving_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2805: IF ( p_action_in_rec.po_need_by_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2806: AND p_action_in_rec.po_need_by_date IS NOT NULL) THEN
2807: RETURN 'N';
2808: END IF;
2809: IF ( p_action_in_rec.receiving_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2810: AND p_action_in_rec.receiving_org_id IS NOT NULL) THEN
2811: RETURN 'N';
2812: END IF;
2813: IF ( p_action_in_rec.receiving_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2813: IF ( p_action_in_rec.receiving_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2809: IF ( p_action_in_rec.receiving_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2810: AND p_action_in_rec.receiving_org_id IS NOT NULL) THEN
2811: RETURN 'N';
2812: END IF;
2813: IF ( p_action_in_rec.receiving_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2814: AND p_action_in_rec.receiving_location_id IS NOT NULL) THEN
2815: RETURN 'N';
2816: END IF;
2817: IF ( p_action_in_rec.vendor_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2817: IF ( p_action_in_rec.vendor_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2813: IF ( p_action_in_rec.receiving_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2814: AND p_action_in_rec.receiving_location_id IS NOT NULL) THEN
2815: RETURN 'N';
2816: END IF;
2817: IF ( p_action_in_rec.vendor_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2818: AND p_action_in_rec.vendor_id IS NOT NULL) THEN
2819: RETURN 'N';
2820: END IF;
2821: IF ( p_action_in_rec.vendor_site_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2821: IF ( p_action_in_rec.vendor_site_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2817: IF ( p_action_in_rec.vendor_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2818: AND p_action_in_rec.vendor_id IS NOT NULL) THEN
2819: RETURN 'N';
2820: END IF;
2821: IF ( p_action_in_rec.vendor_site_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2822: AND p_action_in_rec.vendor_site_code IS NOT NULL) THEN
2823: RETURN 'N';
2824: END IF;
2825: IF ( p_action_in_rec.quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2825: IF ( p_action_in_rec.quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2821: IF ( p_action_in_rec.vendor_site_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2822: AND p_action_in_rec.vendor_site_code IS NOT NULL) THEN
2823: RETURN 'N';
2824: END IF;
2825: IF ( p_action_in_rec.quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2826: AND p_action_in_rec.quantity IS NOT NULL) THEN
2827: RETURN 'N';
2828: END IF;
2829: IF ( p_action_in_rec.uom_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2829: IF ( p_action_in_rec.uom_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2825: IF ( p_action_in_rec.quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2826: AND p_action_in_rec.quantity IS NOT NULL) THEN
2827: RETURN 'N';
2828: END IF;
2829: IF ( p_action_in_rec.uom_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2830: AND p_action_in_rec.uom_code IS NOT NULL) THEN
2831: RETURN 'N';
2832: END IF;
2833: IF ( p_action_in_rec.unit_price <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2833: IF ( p_action_in_rec.unit_price <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2829: IF ( p_action_in_rec.uom_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2830: AND p_action_in_rec.uom_code IS NOT NULL) THEN
2831: RETURN 'N';
2832: END IF;
2833: IF ( p_action_in_rec.unit_price <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2834: AND p_action_in_rec.unit_price IS NOT NULL) THEN
2835: RETURN 'N';
2836: END IF;
2837: IF ( p_action_in_rec.exchange_rate_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2837: IF ( p_action_in_rec.exchange_rate_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2833: IF ( p_action_in_rec.unit_price <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2834: AND p_action_in_rec.unit_price IS NOT NULL) THEN
2835: RETURN 'N';
2836: END IF;
2837: IF ( p_action_in_rec.exchange_rate_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2838: AND p_action_in_rec.exchange_rate_type IS NOT NULL) THEN
2839: RETURN 'N';
2840: END IF;
2841: IF ( p_action_in_rec.exchange_rate_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2841: IF ( p_action_in_rec.exchange_rate_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2837: IF ( p_action_in_rec.exchange_rate_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2838: AND p_action_in_rec.exchange_rate_type IS NOT NULL) THEN
2839: RETURN 'N';
2840: END IF;
2841: IF ( p_action_in_rec.exchange_rate_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2842: AND p_action_in_rec.exchange_rate_date IS NOT NULL) THEN
2843: RETURN 'N';
2844: END IF;
2845: IF ( p_action_in_rec.exchange_rate <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2845: IF ( p_action_in_rec.exchange_rate <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2841: IF ( p_action_in_rec.exchange_rate_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2842: AND p_action_in_rec.exchange_rate_date IS NOT NULL) THEN
2843: RETURN 'N';
2844: END IF;
2845: IF ( p_action_in_rec.exchange_rate <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2846: AND p_action_in_rec.exchange_rate IS NOT NULL) THEN
2847: RETURN 'N';
2848: END IF;
2849: IF ( p_action_in_rec.expenditure_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2849: IF ( p_action_in_rec.expenditure_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2845: IF ( p_action_in_rec.exchange_rate <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2846: AND p_action_in_rec.exchange_rate IS NOT NULL) THEN
2847: RETURN 'N';
2848: END IF;
2849: IF ( p_action_in_rec.expenditure_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2850: AND p_action_in_rec.expenditure_type IS NOT NULL) THEN
2851: RETURN 'N';
2852: END IF;
2853: IF ( p_action_in_rec.expenditure_item_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2853: IF ( p_action_in_rec.expenditure_item_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2849: IF ( p_action_in_rec.expenditure_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2850: AND p_action_in_rec.expenditure_type IS NOT NULL) THEN
2851: RETURN 'N';
2852: END IF;
2853: IF ( p_action_in_rec.expenditure_item_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2854: AND p_action_in_rec.expenditure_item_date IS NOT NULL) THEN
2855: RETURN 'N';
2856: END IF;
2857: IF ( p_action_in_rec.expenditure_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2857: IF ( p_action_in_rec.expenditure_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2853: IF ( p_action_in_rec.expenditure_item_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2854: AND p_action_in_rec.expenditure_item_date IS NOT NULL) THEN
2855: RETURN 'N';
2856: END IF;
2857: IF ( p_action_in_rec.expenditure_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2858: AND p_action_in_rec.expenditure_org_id IS NOT NULL) THEN
2859: RETURN 'N';
2860: END IF;
2861: IF ( p_action_in_rec.requisition_line_type_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2861: IF ( p_action_in_rec.requisition_line_type_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2857: IF ( p_action_in_rec.expenditure_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2858: AND p_action_in_rec.expenditure_org_id IS NOT NULL) THEN
2859: RETURN 'N';
2860: END IF;
2861: IF ( p_action_in_rec.requisition_line_type_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2862: AND p_action_in_rec.requisition_line_type_id IS NOT NULL) THEN
2863: RETURN 'N';
2864: END IF;
2865: IF ( p_action_in_rec.category_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2865: IF ( p_action_in_rec.category_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2861: IF ( p_action_in_rec.requisition_line_type_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2862: AND p_action_in_rec.requisition_line_type_id IS NOT NULL) THEN
2863: RETURN 'N';
2864: END IF;
2865: IF ( p_action_in_rec.category_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2866: AND p_action_in_rec.category_id IS NOT NULL) THEN
2867: RETURN 'N';
2868: END IF;
2869: IF ( p_action_in_rec.ready_to_procure_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2869: IF ( p_action_in_rec.ready_to_procure_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2865: IF ( p_action_in_rec.category_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2866: AND p_action_in_rec.category_id IS NOT NULL) THEN
2867: RETURN 'N';
2868: END IF;
2869: IF ( p_action_in_rec.ready_to_procure_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2870: AND p_action_in_rec.ready_to_procure_flag IS NOT NULL) THEN
2871: RETURN 'N';
2872: END IF;
2873: IF ( p_action_in_rec.initiate_procure_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2873: IF ( p_action_in_rec.initiate_procure_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2869: IF ( p_action_in_rec.ready_to_procure_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2870: AND p_action_in_rec.ready_to_procure_flag IS NOT NULL) THEN
2871: RETURN 'N';
2872: END IF;
2873: IF ( p_action_in_rec.initiate_procure_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2874: AND p_action_in_rec.initiate_procure_flag IS NOT NULL) THEN
2875: RETURN 'N';
2876: END IF;
2877: -- OKE procurement parameters

Line 2882: IF ( p_action_in_rec.ship_from_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2878:
2879: ELSIF ( p_function_code = g_shipping) THEN
2880:
2881: -- OKE shipping parameters
2882: IF ( p_action_in_rec.ship_from_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2883: AND p_action_in_rec.ship_from_organization_id IS NOT NULL) THEN
2884: RETURN 'N';
2885: END IF;
2886: IF ( p_action_in_rec.ship_from_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2886: IF ( p_action_in_rec.ship_from_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2882: IF ( p_action_in_rec.ship_from_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2883: AND p_action_in_rec.ship_from_organization_id IS NOT NULL) THEN
2884: RETURN 'N';
2885: END IF;
2886: IF ( p_action_in_rec.ship_from_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2887: AND p_action_in_rec.ship_from_location_id IS NOT NULL) THEN
2888: RETURN 'N';
2889: END IF;
2890: IF ( p_action_in_rec.ship_to_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2890: IF ( p_action_in_rec.ship_to_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2886: IF ( p_action_in_rec.ship_from_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2887: AND p_action_in_rec.ship_from_location_id IS NOT NULL) THEN
2888: RETURN 'N';
2889: END IF;
2890: IF ( p_action_in_rec.ship_to_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2891: AND p_action_in_rec.ship_to_organization_id IS NOT NULL) THEN
2892: RETURN 'N';
2893: END IF;
2894: IF ( p_action_in_rec.ship_to_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2894: IF ( p_action_in_rec.ship_to_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2890: IF ( p_action_in_rec.ship_to_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2891: AND p_action_in_rec.ship_to_organization_id IS NOT NULL) THEN
2892: RETURN 'N';
2893: END IF;
2894: IF ( p_action_in_rec.ship_to_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2895: AND p_action_in_rec.ship_to_location_id IS NOT NULL) THEN
2896: RETURN 'N';
2897: END IF;
2898: IF ( p_action_in_rec.demand_schedule <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2898: IF ( p_action_in_rec.demand_schedule <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2894: IF ( p_action_in_rec.ship_to_location_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2895: AND p_action_in_rec.ship_to_location_id IS NOT NULL) THEN
2896: RETURN 'N';
2897: END IF;
2898: IF ( p_action_in_rec.demand_schedule <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2899: AND p_action_in_rec.demand_schedule IS NOT NULL) THEN
2900: RETURN 'N';
2901: END IF;
2902: IF ( p_action_in_rec.expected_shipment_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2902: IF ( p_action_in_rec.expected_shipment_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2898: IF ( p_action_in_rec.demand_schedule <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2899: AND p_action_in_rec.demand_schedule IS NOT NULL) THEN
2900: RETURN 'N';
2901: END IF;
2902: IF ( p_action_in_rec.expected_shipment_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2903: AND p_action_in_rec.expected_shipment_date IS NOT NULL) THEN
2904: RETURN 'N';
2905: END IF;
2906: IF ( p_action_in_rec.promised_shipment_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2906: IF ( p_action_in_rec.promised_shipment_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2902: IF ( p_action_in_rec.expected_shipment_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2903: AND p_action_in_rec.expected_shipment_date IS NOT NULL) THEN
2904: RETURN 'N';
2905: END IF;
2906: IF ( p_action_in_rec.promised_shipment_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2907: AND p_action_in_rec.promised_shipment_date IS NOT NULL) THEN
2908: RETURN 'N';
2909: END IF;
2910: IF ( p_action_in_rec.volume <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2910: IF ( p_action_in_rec.volume <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2906: IF ( p_action_in_rec.promised_shipment_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2907: AND p_action_in_rec.promised_shipment_date IS NOT NULL) THEN
2908: RETURN 'N';
2909: END IF;
2910: IF ( p_action_in_rec.volume <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2911: AND p_action_in_rec.volume IS NOT NULL) THEN
2912: RETURN 'N';
2913: END IF;
2914: IF ( p_action_in_rec.volume_uom <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2914: IF ( p_action_in_rec.volume_uom <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2910: IF ( p_action_in_rec.volume <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2911: AND p_action_in_rec.volume IS NOT NULL) THEN
2912: RETURN 'N';
2913: END IF;
2914: IF ( p_action_in_rec.volume_uom <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2915: AND p_action_in_rec.volume_uom IS NOT NULL) THEN
2916: RETURN 'N';
2917: END IF;
2918: IF ( p_action_in_rec.weight <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2918: IF ( p_action_in_rec.weight <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2914: IF ( p_action_in_rec.volume_uom <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2915: AND p_action_in_rec.volume_uom IS NOT NULL) THEN
2916: RETURN 'N';
2917: END IF;
2918: IF ( p_action_in_rec.weight <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2919: AND p_action_in_rec.weight IS NOT NULL) THEN
2920: RETURN 'N';
2921: END IF;
2922: IF ( p_action_in_rec.weight_uom <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2922: IF ( p_action_in_rec.weight_uom <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2918: IF ( p_action_in_rec.weight <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2919: AND p_action_in_rec.weight IS NOT NULL) THEN
2920: RETURN 'N';
2921: END IF;
2922: IF ( p_action_in_rec.weight_uom <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2923: AND p_action_in_rec.weight_uom IS NOT NULL) THEN
2924: RETURN 'N';
2925: END IF;
2926: IF ( p_action_in_rec.ready_to_ship_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2926: IF ( p_action_in_rec.ready_to_ship_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2922: IF ( p_action_in_rec.weight_uom <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2923: AND p_action_in_rec.weight_uom IS NOT NULL) THEN
2924: RETURN 'N';
2925: END IF;
2926: IF ( p_action_in_rec.ready_to_ship_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2927: AND p_action_in_rec.ready_to_ship_flag IS NOT NULL) THEN
2928: RETURN 'N';
2929: END IF;
2930: IF ( p_action_in_rec.initiate_planning_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2930: IF ( p_action_in_rec.initiate_planning_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2926: IF ( p_action_in_rec.ready_to_ship_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2927: AND p_action_in_rec.ready_to_ship_flag IS NOT NULL) THEN
2928: RETURN 'N';
2929: END IF;
2930: IF ( p_action_in_rec.initiate_planning_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2931: AND p_action_in_rec.initiate_planning_flag IS NOT NULL) THEN
2932: RETURN 'N';
2933: END IF;
2934: IF ( p_action_in_rec.initiate_shipping_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2934: IF ( p_action_in_rec.initiate_shipping_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2930: IF ( p_action_in_rec.initiate_planning_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2931: AND p_action_in_rec.initiate_planning_flag IS NOT NULL) THEN
2932: RETURN 'N';
2933: END IF;
2934: IF ( p_action_in_rec.initiate_shipping_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2935: AND p_action_in_rec.initiate_shipping_flag IS NOT NULL) THEN
2936: RETURN 'N';
2937: END IF;
2938: IF ( p_action_in_rec.quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2938: IF ( p_action_in_rec.quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2934: IF ( p_action_in_rec.initiate_shipping_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2935: AND p_action_in_rec.initiate_shipping_flag IS NOT NULL) THEN
2936: RETURN 'N';
2937: END IF;
2938: IF ( p_action_in_rec.quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2939: AND p_action_in_rec.quantity IS NOT NULL) THEN
2940: RETURN 'N';
2941: END IF;
2942: IF ( p_action_in_rec.uom_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2942: IF ( p_action_in_rec.uom_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2938: IF ( p_action_in_rec.quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2939: AND p_action_in_rec.quantity IS NOT NULL) THEN
2940: RETURN 'N';
2941: END IF;
2942: IF ( p_action_in_rec.uom_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2943: AND p_action_in_rec.uom_code IS NOT NULL) THEN
2944: RETURN 'N';
2945: END IF;
2946: -- OKE shipping parameters

Line 3201: IF ( p_action_in_tbl(i_actn).action_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

3197: WHILE i_actn IS NOT NULL LOOP
3198:
3199: /* Bug # 3590235 : Added a condition to check null value for action_owner_id */
3200:
3201: IF ( p_action_in_tbl(i_actn).action_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
3202: p_action_in_tbl(i_actn).action_owner_id IS NULL) THEN
3203: l_action_owner_id := null;
3204: ELSE
3205: l_action_owner_id := p_action_in_tbl(i_actn).action_owner_id ;

Line 3324: IF p_action_in_tbl(i_actn).action_name IS NULL OR p_action_in_tbl(i_actn).action_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

3320: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3321: RAISE FND_API.G_EXC_ERROR;
3322: END IF;
3323:
3324: IF p_action_in_tbl(i_actn).action_name IS NULL OR p_action_in_tbl(i_actn).action_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3325:
3326: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3327: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_NAME_NULL_ERROR') ;
3328: PA_UTILS.ADD_MESSAGE

Line 3393: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )

3389:
3390: -- Changed the direct initialization of local variables to select statement as values would differ in case of update or create bug 3651139
3391: IF (l_action = g_create) THEN
3392: SELECT
3393: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3394: , l_action_owner_id
3395: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).function_code )
3396: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).due_date )
3397: , NULL --l_completed_flag

Line 3395: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).function_code )

3391: IF (l_action = g_create) THEN
3392: SELECT
3393: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3394: , l_action_owner_id
3395: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).function_code )
3396: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).due_date )
3397: , NULL --l_completed_flag
3398: , NULL --l_completion_date
3399: , NULL --l_element_version_id

Line 3396: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).due_date )

3392: SELECT
3393: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3394: , l_action_owner_id
3395: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).function_code )
3396: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).due_date )
3397: , NULL --l_completed_flag
3398: , NULL --l_completion_date
3399: , NULL --l_element_version_id
3400: , NULL --l_proj_element_id

Line 3402: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).description )

3398: , NULL --l_completion_date
3399: , NULL --l_element_version_id
3400: , NULL --l_proj_element_id
3401: , 1 --l_rec_ver_num_id
3402: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).description )
3403: , p_insert_or_update
3404: , decode(p_action_in_tbl(i_actn).pm_action_reference,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).pm_action_reference )
3405: , NULL --l_attribute_category
3406: , NULL --l_attribute1

Line 3404: , decode(p_action_in_tbl(i_actn).pm_action_reference,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).pm_action_reference )

3400: , NULL --l_proj_element_id
3401: , 1 --l_rec_ver_num_id
3402: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).description )
3403: , p_insert_or_update
3404: , decode(p_action_in_tbl(i_actn).pm_action_reference,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).pm_action_reference )
3405: , NULL --l_attribute_category
3406: , NULL --l_attribute1
3407: , NULL --l_attribute2
3408: , NULL --l_attribute3

Line 3453: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , element_name , p_action_in_tbl(i_actn).action_name )

3449: , l_attribute15_tbl(i_actn)
3450: FROM DUAL;
3451: ELSE -- UPDATE
3452: SELECT
3453: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , element_name , p_action_in_tbl(i_actn).action_name )
3454: , decode(p_action_in_tbl(i_actn).action_owner_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , manager_person_id, p_action_in_tbl(i_actn).action_owner_id )
3455: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , function_code , p_action_in_tbl(i_actn).function_code )
3456: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , due_date , p_action_in_tbl(i_actn).due_date )
3457: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag

Line 3454: , decode(p_action_in_tbl(i_actn).action_owner_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , manager_person_id, p_action_in_tbl(i_actn).action_owner_id )

3450: FROM DUAL;
3451: ELSE -- UPDATE
3452: SELECT
3453: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , element_name , p_action_in_tbl(i_actn).action_name )
3454: , decode(p_action_in_tbl(i_actn).action_owner_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , manager_person_id, p_action_in_tbl(i_actn).action_owner_id )
3455: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , function_code , p_action_in_tbl(i_actn).function_code )
3456: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , due_date , p_action_in_tbl(i_actn).due_date )
3457: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag
3458: , decode(p_action_in_tbl(i_actn).completion_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , actual_finish_date, p_action_in_tbl(i_actn).completion_date ) -- for bug# 3749462-- earlier passed as NULL --l_completion_date

Line 3455: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , function_code , p_action_in_tbl(i_actn).function_code )

3451: ELSE -- UPDATE
3452: SELECT
3453: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , element_name , p_action_in_tbl(i_actn).action_name )
3454: , decode(p_action_in_tbl(i_actn).action_owner_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , manager_person_id, p_action_in_tbl(i_actn).action_owner_id )
3455: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , function_code , p_action_in_tbl(i_actn).function_code )
3456: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , due_date , p_action_in_tbl(i_actn).due_date )
3457: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag
3458: , decode(p_action_in_tbl(i_actn).completion_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , actual_finish_date, p_action_in_tbl(i_actn).completion_date ) -- for bug# 3749462-- earlier passed as NULL --l_completion_date
3459: , element_version_id

Line 3456: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , due_date , p_action_in_tbl(i_actn).due_date )

3452: SELECT
3453: decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , element_name , p_action_in_tbl(i_actn).action_name )
3454: , decode(p_action_in_tbl(i_actn).action_owner_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , manager_person_id, p_action_in_tbl(i_actn).action_owner_id )
3455: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , function_code , p_action_in_tbl(i_actn).function_code )
3456: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , due_date , p_action_in_tbl(i_actn).due_date )
3457: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag
3458: , decode(p_action_in_tbl(i_actn).completion_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , actual_finish_date, p_action_in_tbl(i_actn).completion_date ) -- for bug# 3749462-- earlier passed as NULL --l_completion_date
3459: , element_version_id
3460: , proj_element_id

Line 3458: , decode(p_action_in_tbl(i_actn).completion_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , actual_finish_date, p_action_in_tbl(i_actn).completion_date ) -- for bug# 3749462-- earlier passed as NULL --l_completion_date

3454: , decode(p_action_in_tbl(i_actn).action_owner_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , manager_person_id, p_action_in_tbl(i_actn).action_owner_id )
3455: , decode(p_action_in_tbl(i_actn).function_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , function_code , p_action_in_tbl(i_actn).function_code )
3456: , decode(p_action_in_tbl(i_actn).due_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , due_date , p_action_in_tbl(i_actn).due_date )
3457: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag
3458: , decode(p_action_in_tbl(i_actn).completion_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , actual_finish_date, p_action_in_tbl(i_actn).completion_date ) -- for bug# 3749462-- earlier passed as NULL --l_completion_date
3459: , element_version_id
3460: , proj_element_id
3461: , NULL --l_rec_ver_num_id
3462: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_action_in_tbl(i_actn).description )

Line 3462: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_action_in_tbl(i_actn).description )

3458: , decode(p_action_in_tbl(i_actn).completion_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , actual_finish_date, p_action_in_tbl(i_actn).completion_date ) -- for bug# 3749462-- earlier passed as NULL --l_completion_date
3459: , element_version_id
3460: , proj_element_id
3461: , NULL --l_rec_ver_num_id
3462: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_action_in_tbl(i_actn).description )
3463: -- 3729250 removed p_insert_or_update passing , for update expected value is 'MODIFIED'
3464: -- because CR_UP_DLV_ACTIONS_IN_BULK procedure is expecting this value to be 'MODIFIED' , not 'UPDATE'
3465: , g_modified
3466: , decode(p_action_in_tbl(i_actn).pm_action_reference,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).pm_action_reference )

Line 3466: , decode(p_action_in_tbl(i_actn).pm_action_reference,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).pm_action_reference )

3462: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_action_in_tbl(i_actn).description )
3463: -- 3729250 removed p_insert_or_update passing , for update expected value is 'MODIFIED'
3464: -- because CR_UP_DLV_ACTIONS_IN_BULK procedure is expecting this value to be 'MODIFIED' , not 'UPDATE'
3465: , g_modified
3466: , decode(p_action_in_tbl(i_actn).pm_action_reference,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).pm_action_reference )
3467: , attribute_category
3468: , attribute1
3469: , attribute2
3470: , attribute3

Line 3520: IF p_action_in_tbl(i_actn).action_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

3516: -- 3651542 if create mode , check action_owner_id and due_date is not passed
3517: -- set default owner id and due date to local variable
3518:
3519: IF (l_action = g_create) THEN
3520: IF p_action_in_tbl(i_actn).action_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3521: l_action_owner_id_tbl(i_actn) := l_default_owner_id;
3522: END IF;
3523:
3524: IF p_action_in_tbl(i_actn).due_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

Line 3524: IF p_action_in_tbl(i_actn).due_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

3520: IF p_action_in_tbl(i_actn).action_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3521: l_action_owner_id_tbl(i_actn) := l_default_owner_id;
3522: END IF;
3523:
3524: IF p_action_in_tbl(i_actn).due_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
3525: l_due_date_tbl(i_actn) := l_default_date;
3526: END IF;
3527: END IF;
3528:

Line 3536: IF ( p_action_in_tbl(i_actn).financial_task_id IS NOT NULL AND p_action_in_tbl(i_actn).financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) THEN

3532: l_fin_task_ref := NULL;
3533:
3534: -- if passed financial task id or reference is not passed , set it to null
3535:
3536: IF ( p_action_in_tbl(i_actn).financial_task_id IS NOT NULL AND p_action_in_tbl(i_actn).financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) THEN
3537: l_fin_task_id := p_action_in_tbl(i_actn).financial_task_id;
3538: END IF;
3539:
3540: IF ( p_action_in_tbl(i_actn).financial_task_reference IS NOT NULL AND p_action_in_tbl(i_actn).financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

Line 3540: IF ( p_action_in_tbl(i_actn).financial_task_reference IS NOT NULL AND p_action_in_tbl(i_actn).financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

3536: IF ( p_action_in_tbl(i_actn).financial_task_id IS NOT NULL AND p_action_in_tbl(i_actn).financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) THEN
3537: l_fin_task_id := p_action_in_tbl(i_actn).financial_task_id;
3538: END IF;
3539:
3540: IF ( p_action_in_tbl(i_actn).financial_task_reference IS NOT NULL AND p_action_in_tbl(i_actn).financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
3541: l_fin_task_ref := p_action_in_tbl(i_actn).financial_task_reference;
3542: END IF;
3543:
3544: -- if task reference / id is passed , validate passed reference with id

Line 3639: l_fin_task_num_tbl(i_actn) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

3635: Close is_top_task;
3636:
3637: END IF;
3638: ELSE
3639: l_fin_task_num_tbl(i_actn) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
3640: END IF;
3641:
3642: -- for bug# 3749462
3643: -- create mode, completion date is null and comleted flag will become 'N'

Line 3791: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )

3787:
3788: IF (l_action = g_create) THEN -- added IF condition and else part of the code bug 3651139
3789: SELECT l_object_version_id
3790: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3791: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3792: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3793: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).destination_type_code )
3794: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_org_id )
3795: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_location_id )

Line 3792: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462

3788: IF (l_action = g_create) THEN -- added IF condition and else part of the code bug 3651139
3789: SELECT l_object_version_id
3790: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3791: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3792: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3793: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).destination_type_code )
3794: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_org_id )
3795: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_location_id )
3796: -- 3729250 , po_need_by_date should be populated with procurement action due date

Line 3793: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).destination_type_code )

3789: SELECT l_object_version_id
3790: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3791: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3792: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3793: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).destination_type_code )
3794: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_org_id )
3795: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_location_id )
3796: -- 3729250 , po_need_by_date should be populated with procurement action due date
3797: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date

Line 3794: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_org_id )

3790: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3791: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3792: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3793: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).destination_type_code )
3794: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_org_id )
3795: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_location_id )
3796: -- 3729250 , po_need_by_date should be populated with procurement action due date
3797: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3798: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it

Line 3795: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_location_id )

3791: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3792: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3793: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).destination_type_code )
3794: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_org_id )
3795: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_location_id )
3796: -- 3729250 , po_need_by_date should be populated with procurement action due date
3797: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3798: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3799: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).vendor_id )

Line 3799: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).vendor_id )

3795: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).receiving_location_id )
3796: -- 3729250 , po_need_by_date should be populated with procurement action due date
3797: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3798: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3799: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).vendor_id )
3800: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).vendor_site_code )
3801: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )
3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )

Line 3800: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).vendor_site_code )

3796: -- 3729250 , po_need_by_date should be populated with procurement action due date
3797: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3798: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3799: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).vendor_id )
3800: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).vendor_site_code )
3801: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )
3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )
3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )

Line 3801: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )

3797: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3798: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3799: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).vendor_id )
3800: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).vendor_site_code )
3801: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )
3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )
3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )
3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )

Line 3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )

3798: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3799: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).vendor_id )
3800: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).vendor_site_code )
3801: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )
3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )
3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )
3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )
3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )

Line 3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )

3799: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).vendor_id )
3800: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).vendor_site_code )
3801: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )
3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )
3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )
3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )
3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )
3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )

Line 3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )

3800: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).vendor_site_code )
3801: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )
3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )
3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )
3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )
3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )
3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )
3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )

Line 3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )

3801: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )
3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )
3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )
3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )
3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )
3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )
3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )
3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )

Line 3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )

3802: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).unit_price )
3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )
3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )
3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )
3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )
3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )
3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )
3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )
3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )

Line 3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )

3803: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).exchange_rate_type )
3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )
3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )
3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )
3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )
3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )
3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )
3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )
3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )

Line 3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )

3804: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).exchange_rate_date )
3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )
3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )
3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )
3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )
3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )
3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )
3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )
3812: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_procure_flag )

Line 3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )

3805: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).exchange_rate )
3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )
3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )
3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )
3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )
3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )
3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )
3812: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_procure_flag )
3813: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )

Line 3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )

3806: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).expenditure_type )
3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )
3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )
3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )
3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )
3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )
3812: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_procure_flag )
3813: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3814: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )

Line 3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )

3807: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).expenditure_org_id )
3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )
3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )
3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )
3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )
3812: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_procure_flag )
3813: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3814: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )
3815: INTO

Line 3812: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_procure_flag )

3808: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).expenditure_item_date )
3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )
3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )
3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )
3812: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_procure_flag )
3813: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3814: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )
3815: INTO
3816: l_dlv_req_action_tbl(i_proc).pa_deliverable_id

Line 3813: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )

3809: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).requisition_line_type_id )
3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )
3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )
3812: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_procure_flag )
3813: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3814: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )
3815: INTO
3816: l_dlv_req_action_tbl(i_proc).pa_deliverable_id
3817: , l_dlv_req_action_tbl(i_proc).pa_action_id

Line 3814: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )

3810: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).category_id )
3811: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_procure_flag )
3812: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_procure_flag )
3813: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3814: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )
3815: INTO
3816: l_dlv_req_action_tbl(i_proc).pa_deliverable_id
3817: , l_dlv_req_action_tbl(i_proc).pa_action_id
3818: , l_dlv_req_action_tbl(i_proc).action_name

Line 3846: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )

3842: ELSE -- UPDATE
3843:
3844: SELECT l_object_version_id
3845: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3846: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )
3847: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3848: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , destination_type_code , p_action_in_tbl(i_actn).destination_type_code )
3849: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).receiving_org_id )
3850: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).receiving_location_id )

Line 3848: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , destination_type_code , p_action_in_tbl(i_actn).destination_type_code )

3844: SELECT l_object_version_id
3845: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3846: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )
3847: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3848: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , destination_type_code , p_action_in_tbl(i_actn).destination_type_code )
3849: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).receiving_org_id )
3850: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).receiving_location_id )
3851: -- 3729250 , po_need_by_date should be populated with procurement action due date
3852: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)

Line 3849: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).receiving_org_id )

3845: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3846: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )
3847: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3848: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , destination_type_code , p_action_in_tbl(i_actn).destination_type_code )
3849: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).receiving_org_id )
3850: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).receiving_location_id )
3851: -- 3729250 , po_need_by_date should be populated with procurement action due date
3852: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3853: , l_due_date_tbl(i_actn)

Line 3850: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).receiving_location_id )

3846: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )
3847: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3848: , decode(p_action_in_tbl(i_actn).destination_type_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , destination_type_code , p_action_in_tbl(i_actn).destination_type_code )
3849: , decode(p_action_in_tbl(i_actn).receiving_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).receiving_org_id )
3850: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).receiving_location_id )
3851: -- 3729250 , po_need_by_date should be populated with procurement action due date
3852: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3853: , l_due_date_tbl(i_actn)
3854: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).vendor_id )

Line 3854: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).vendor_id )

3850: , decode(p_action_in_tbl(i_actn).receiving_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).receiving_location_id )
3851: -- 3729250 , po_need_by_date should be populated with procurement action due date
3852: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3853: , l_due_date_tbl(i_actn)
3854: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).vendor_id )
3855: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ship_from_location_id , p_action_in_tbl(i_actn).vendor_site_code )
3856: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )
3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )

Line 3855: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ship_from_location_id , p_action_in_tbl(i_actn).vendor_site_code )

3851: -- 3729250 , po_need_by_date should be populated with procurement action due date
3852: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3853: , l_due_date_tbl(i_actn)
3854: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).vendor_id )
3855: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ship_from_location_id , p_action_in_tbl(i_actn).vendor_site_code )
3856: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )
3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )
3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )

Line 3856: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )

3852: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3853: , l_due_date_tbl(i_actn)
3854: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).vendor_id )
3855: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ship_from_location_id , p_action_in_tbl(i_actn).vendor_site_code )
3856: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )
3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )
3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )
3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )

Line 3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )

3853: , l_due_date_tbl(i_actn)
3854: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).vendor_id )
3855: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ship_from_location_id , p_action_in_tbl(i_actn).vendor_site_code )
3856: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )
3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )
3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )
3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )
3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )

Line 3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )

3854: , decode(p_action_in_tbl(i_actn).vendor_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).vendor_id )
3855: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ship_from_location_id , p_action_in_tbl(i_actn).vendor_site_code )
3856: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )
3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )
3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )
3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )
3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )
3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )

Line 3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )

3855: , decode(p_action_in_tbl(i_actn).vendor_site_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ship_from_location_id , p_action_in_tbl(i_actn).vendor_site_code )
3856: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )
3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )
3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )
3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )
3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )
3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )
3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )

Line 3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )

3856: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )
3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )
3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )
3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )
3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )
3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )
3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )
3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )

Line 3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )

3857: , decode(p_action_in_tbl(i_actn).unit_price ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price , p_action_in_tbl(i_actn).unit_price )
3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )
3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )
3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )
3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )
3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )
3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )
3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )
3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )

Line 3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )

3858: , decode(p_action_in_tbl(i_actn).exchange_rate_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , rate_type , p_action_in_tbl(i_actn).exchange_rate_type )
3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )
3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )
3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )
3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )
3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )
3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )
3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )
3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )

Line 3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )

3859: , decode(p_action_in_tbl(i_actn).exchange_rate_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , rate_date , p_action_in_tbl(i_actn).exchange_rate_date )
3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )
3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )
3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )
3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )
3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )
3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )
3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )
3867: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_procure_flag )

Line 3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )

3860: , decode(p_action_in_tbl(i_actn).exchange_rate ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , exchange_rate , p_action_in_tbl(i_actn).exchange_rate )
3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )
3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )
3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )
3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )
3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )
3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )
3867: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_procure_flag )
3868: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )

Line 3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )

3861: , decode(p_action_in_tbl(i_actn).expenditure_type ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , expenditure_type , p_action_in_tbl(i_actn).expenditure_type )
3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )
3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )
3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )
3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )
3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )
3867: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_procure_flag )
3868: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3869: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code , p_action_in_tbl(i_actn).currency )

Line 3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )

3862: , decode(p_action_in_tbl(i_actn).expenditure_org_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , expenditure_organization_id, p_action_in_tbl(i_actn).expenditure_org_id )
3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )
3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )
3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )
3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )
3867: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_procure_flag )
3868: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3869: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code , p_action_in_tbl(i_actn).currency )
3870: INTO

Line 3867: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_procure_flag )

3863: , decode(p_action_in_tbl(i_actn).expenditure_item_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , expenditure_item_date , p_action_in_tbl(i_actn).expenditure_item_date )
3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )
3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )
3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )
3867: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_procure_flag )
3868: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3869: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code , p_action_in_tbl(i_actn).currency )
3870: INTO
3871: l_dlv_req_action_tbl(i_proc).pa_deliverable_id

Line 3868: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )

3864: , decode(p_action_in_tbl(i_actn).requisition_line_type_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , requisition_line_type_id, p_action_in_tbl(i_actn).requisition_line_type_id )
3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )
3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )
3867: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_procure_flag )
3868: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3869: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code , p_action_in_tbl(i_actn).currency )
3870: INTO
3871: l_dlv_req_action_tbl(i_proc).pa_deliverable_id
3872: , l_dlv_req_action_tbl(i_proc).pa_action_id

Line 3869: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code , p_action_in_tbl(i_actn).currency )

3865: , decode(p_action_in_tbl(i_actn).category_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , po_category_id , p_action_in_tbl(i_actn).category_id )
3866: , decode(p_action_in_tbl(i_actn).ready_to_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).ready_to_procure_flag )
3867: , decode(p_action_in_tbl(i_actn).initiate_procure_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_procure_flag )
3868: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3869: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code , p_action_in_tbl(i_actn).currency )
3870: INTO
3871: l_dlv_req_action_tbl(i_proc).pa_deliverable_id
3872: , l_dlv_req_action_tbl(i_proc).pa_action_id
3873: , l_dlv_req_action_tbl(i_proc).action_name

Line 3915: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )

3911:
3912: IF (l_action = g_create) THEN -- added IF condition and else part of the code bug 3651139
3913: SELECT l_object_version_id
3914: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3915: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3916: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3917: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).demand_schedule )
3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )
3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )

Line 3916: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462

3912: IF (l_action = g_create) THEN -- added IF condition and else part of the code bug 3651139
3913: SELECT l_object_version_id
3914: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3915: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3916: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3917: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).demand_schedule )
3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )
3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )
3920: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_organization_id )

Line 3917: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).demand_schedule )

3913: SELECT l_object_version_id
3914: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3915: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3916: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3917: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).demand_schedule )
3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )
3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )
3920: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_organization_id )
3921: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_location_id )

Line 3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )

3914: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3915: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3916: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3917: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).demand_schedule )
3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )
3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )
3920: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_organization_id )
3921: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_location_id )
3922: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).promised_shipment_date )

Line 3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )

3915: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).action_name )
3916: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3917: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).demand_schedule )
3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )
3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )
3920: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_organization_id )
3921: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_location_id )
3922: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).promised_shipment_date )
3923: -- 3729250 , expected_shipment_date should be populated with shipping action due date

Line 3920: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_organization_id )

3916: , decode(l_fin_task_id_tbl(i_actn) ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3917: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).demand_schedule )
3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )
3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )
3920: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_organization_id )
3921: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_location_id )
3922: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).promised_shipment_date )
3923: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3924: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date

Line 3921: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_location_id )

3917: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).demand_schedule )
3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )
3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )
3920: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_organization_id )
3921: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_location_id )
3922: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).promised_shipment_date )
3923: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3924: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3925: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it

Line 3922: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).promised_shipment_date )

3918: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_organization_id )
3919: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_from_location_id )
3920: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_organization_id )
3921: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).ship_to_location_id )
3922: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).promised_shipment_date )
3923: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3924: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3925: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3926: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )

Line 3926: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )

3922: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , null, p_action_in_tbl(i_actn).promised_shipment_date )
3923: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3924: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3925: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3926: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3927: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).volume_uom )
3928: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )
3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )

Line 3927: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).volume_uom )

3923: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3924: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3925: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3926: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3927: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).volume_uom )
3928: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )
3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )
3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )

Line 3928: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )

3924: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3925: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3926: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3927: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).volume_uom )
3928: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )
3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )
3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )
3932: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_shipping_flag )

Line 3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )

3925: , l_due_date_tbl(i_actn) -- 3651542 Using local variable , if defaulting is done p_action_in_tbl(i_actn).due_date will not reflect it
3926: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3927: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).volume_uom )
3928: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )
3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )
3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )
3932: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_shipping_flag )
3933: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )

Line 3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )

3926: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3927: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).volume_uom )
3928: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )
3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )
3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )
3932: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_shipping_flag )
3933: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3934: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )

Line 3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )

3927: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).volume_uom )
3928: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )
3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )
3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )
3932: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_shipping_flag )
3933: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3934: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3935: INTO

Line 3932: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_shipping_flag )

3928: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )
3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )
3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )
3932: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_shipping_flag )
3933: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3934: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3935: INTO
3936: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id

Line 3933: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )

3929: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).weight_uom )
3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )
3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )
3932: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_shipping_flag )
3933: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3934: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3935: INTO
3936: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id
3937: , l_dlv_ship_action_tbl(i_ship).pa_action_id

Line 3934: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )

3930: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).ready_to_ship_flag )
3931: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_planning_flag )
3932: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).initiate_shipping_flag )
3933: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).uom_code )
3934: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3935: INTO
3936: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id
3937: , l_dlv_ship_action_tbl(i_ship).pa_action_id
3938: , l_dlv_ship_action_tbl(i_ship).action_name

Line 3961: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )

3957:
3958: ELSE -- UPDATE
3959: SELECT l_object_version_id
3960: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3961: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )
3962: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3963: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , schedule_designator , p_action_in_tbl(i_actn).demand_schedule )
3964: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).ship_from_organization_id )
3965: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_location_id , p_action_in_tbl(i_actn).ship_from_location_id )

Line 3963: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , schedule_designator , p_action_in_tbl(i_actn).demand_schedule )

3959: SELECT l_object_version_id
3960: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3961: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )
3962: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3963: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , schedule_designator , p_action_in_tbl(i_actn).demand_schedule )
3964: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).ship_from_organization_id )
3965: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_location_id , p_action_in_tbl(i_actn).ship_from_location_id )
3966: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).ship_to_organization_id )
3967: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).ship_to_location_id )

Line 3964: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).ship_from_organization_id )

3960: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3961: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )
3962: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3963: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , schedule_designator , p_action_in_tbl(i_actn).demand_schedule )
3964: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).ship_from_organization_id )
3965: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_location_id , p_action_in_tbl(i_actn).ship_from_location_id )
3966: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).ship_to_organization_id )
3967: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).ship_to_location_id )
3968: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , promised_date , p_action_in_tbl(i_actn).promised_shipment_date )

Line 3965: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_location_id , p_action_in_tbl(i_actn).ship_from_location_id )

3961: , decode(p_action_in_tbl(i_actn).action_name ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , action_name , p_action_in_tbl(i_actn).action_name )
3962: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3963: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , schedule_designator , p_action_in_tbl(i_actn).demand_schedule )
3964: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).ship_from_organization_id )
3965: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_location_id , p_action_in_tbl(i_actn).ship_from_location_id )
3966: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).ship_to_organization_id )
3967: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).ship_to_location_id )
3968: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , promised_date , p_action_in_tbl(i_actn).promised_shipment_date )
3969: -- 3729250 , expected_shipment_date should be populated with shipping action due date

Line 3966: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).ship_to_organization_id )

3962: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3963: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , schedule_designator , p_action_in_tbl(i_actn).demand_schedule )
3964: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).ship_from_organization_id )
3965: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_location_id , p_action_in_tbl(i_actn).ship_from_location_id )
3966: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).ship_to_organization_id )
3967: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).ship_to_location_id )
3968: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , promised_date , p_action_in_tbl(i_actn).promised_shipment_date )
3969: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3970: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)

Line 3967: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).ship_to_location_id )

3963: , decode(p_action_in_tbl(i_actn).demand_schedule ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , schedule_designator , p_action_in_tbl(i_actn).demand_schedule )
3964: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).ship_from_organization_id )
3965: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_location_id , p_action_in_tbl(i_actn).ship_from_location_id )
3966: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).ship_to_organization_id )
3967: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).ship_to_location_id )
3968: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , promised_date , p_action_in_tbl(i_actn).promised_shipment_date )
3969: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3970: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3971: , l_due_date_tbl(i_actn)

Line 3968: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , promised_date , p_action_in_tbl(i_actn).promised_shipment_date )

3964: , decode(p_action_in_tbl(i_actn).ship_from_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_org_id , p_action_in_tbl(i_actn).ship_from_organization_id )
3965: , decode(p_action_in_tbl(i_actn).ship_from_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_from_location_id , p_action_in_tbl(i_actn).ship_from_location_id )
3966: , decode(p_action_in_tbl(i_actn).ship_to_organization_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_org_id , p_action_in_tbl(i_actn).ship_to_organization_id )
3967: , decode(p_action_in_tbl(i_actn).ship_to_location_id ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , ship_to_location_id , p_action_in_tbl(i_actn).ship_to_location_id )
3968: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , promised_date , p_action_in_tbl(i_actn).promised_shipment_date )
3969: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3970: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3971: , l_due_date_tbl(i_actn)
3972: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )

Line 3972: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )

3968: , decode(p_action_in_tbl(i_actn).promised_shipment_date ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE , promised_date , p_action_in_tbl(i_actn).promised_shipment_date )
3969: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3970: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3971: , l_due_date_tbl(i_actn)
3972: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3973: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , volume_uom_code , p_action_in_tbl(i_actn).volume_uom )
3974: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )
3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )

Line 3973: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , volume_uom_code , p_action_in_tbl(i_actn).volume_uom )

3969: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3970: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3971: , l_due_date_tbl(i_actn)
3972: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3973: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , volume_uom_code , p_action_in_tbl(i_actn).volume_uom )
3974: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )
3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )
3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )

Line 3974: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )

3970: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3971: , l_due_date_tbl(i_actn)
3972: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3973: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , volume_uom_code , p_action_in_tbl(i_actn).volume_uom )
3974: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )
3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )
3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )
3978: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_shipping_flag )

Line 3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )

3971: , l_due_date_tbl(i_actn)
3972: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3973: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , volume_uom_code , p_action_in_tbl(i_actn).volume_uom )
3974: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )
3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )
3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )
3978: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_shipping_flag )
3979: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )

Line 3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )

3972: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3973: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , volume_uom_code , p_action_in_tbl(i_actn).volume_uom )
3974: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )
3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )
3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )
3978: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_shipping_flag )
3979: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3980: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )

Line 3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )

3973: , decode(p_action_in_tbl(i_actn).volume_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , volume_uom_code , p_action_in_tbl(i_actn).volume_uom )
3974: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )
3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )
3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )
3978: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_shipping_flag )
3979: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3980: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3981: INTO

Line 3978: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_shipping_flag )

3974: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )
3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )
3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )
3978: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_shipping_flag )
3979: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3980: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3981: INTO
3982: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id

Line 3979: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )

3975: , decode(p_action_in_tbl(i_actn).weight_uom ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , weight_uom_code , p_action_in_tbl(i_actn).weight_uom )
3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )
3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )
3978: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_shipping_flag )
3979: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3980: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3981: INTO
3982: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id
3983: , l_dlv_ship_action_tbl(i_ship).pa_action_id

Line 3980: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )

3976: , decode(p_action_in_tbl(i_actn).ready_to_ship_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , ready_flag , p_action_in_tbl(i_actn).ready_to_ship_flag )
3977: , decode(p_action_in_tbl(i_actn).initiate_planning_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_planning_flag )
3978: , decode(p_action_in_tbl(i_actn).initiate_shipping_flag ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null , p_action_in_tbl(i_actn).initiate_shipping_flag )
3979: , decode(p_action_in_tbl(i_actn).uom_code ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code , p_action_in_tbl(i_actn).uom_code )
3980: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3981: INTO
3982: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id
3983: , l_dlv_ship_action_tbl(i_ship).pa_action_id
3984: , l_dlv_ship_action_tbl(i_ship).action_name

Line 4018: -- 4027500 Passing l_organization_name as PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR if update mode and p_organization_id

4014: -- and so below condition was failing and oke data was not getting updated
4015: -- changed from p_action_in_tbl(i_actn).function_code to l_function_code_tbl(i_actn)
4016: ELSIF ( l_function_code_tbl(i_actn) = g_billing) THEN
4017:
4018: -- 4027500 Passing l_organization_name as PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR if update mode and p_organization_id
4019: -- is not passed
4020: -- else call C_org_name to derive organization_name from id
4021: IF p_insert_or_update = g_update AND p_action_in_tbl(i_actn).organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4022: l_organization_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

Line 4021: IF p_insert_or_update = g_update AND p_action_in_tbl(i_actn).organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4017:
4018: -- 4027500 Passing l_organization_name as PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR if update mode and p_organization_id
4019: -- is not passed
4020: -- else call C_org_name to derive organization_name from id
4021: IF p_insert_or_update = g_update AND p_action_in_tbl(i_actn).organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4022: l_organization_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
4023: ELSE
4024: OPEN C_org_name(p_action_in_tbl(i_actn).organization_id);
4025: FETCH C_org_name INTO l_organization_name;

Line 4022: l_organization_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

4018: -- 4027500 Passing l_organization_name as PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR if update mode and p_organization_id
4019: -- is not passed
4020: -- else call C_org_name to derive organization_name from id
4021: IF p_insert_or_update = g_update AND p_action_in_tbl(i_actn).organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4022: l_organization_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
4023: ELSE
4024: OPEN C_org_name(p_action_in_tbl(i_actn).organization_id);
4025: FETCH C_org_name INTO l_organization_name;
4026: IF (C_org_name%rowcount = 0 ) THEN

Line 4291: PA_INTERFACE_UTILS_PUB.get_messages

4287: l_msg_count := FND_MSG_PUB.count_msg;
4288:
4289: IF l_msg_count = 1 AND x_msg_data IS NULL
4290: THEN
4291: PA_INTERFACE_UTILS_PUB.get_messages
4292: (p_encoded => FND_API.G_FALSE,
4293: p_msg_index => 1,
4294: p_msg_count => x_msg_count,
4295: p_msg_data => l_msg_data,

Line 4320: PA_INTERFACE_UTILS_PUB.get_messages

4316: l_msg_count := FND_MSG_PUB.count_msg;
4317:
4318: IF l_msg_count = 1 AND x_msg_data IS NULL
4319: THEN
4320: PA_INTERFACE_UTILS_PUB.get_messages
4321: (p_encoded => FND_API.G_FALSE,
4322: p_msg_index => 1,
4323: p_msg_count => x_msg_count,
4324: p_msg_data => l_msg_data,

Line 4746: PA_INTERFACE_UTILS_PUB.get_messages

4742: CLOSE c_valid_project_number_entry ;
4743: END IF ;
4744:
4745: IF l_msg_count >= 1 THEN
4746: PA_INTERFACE_UTILS_PUB.get_messages
4747: (p_encoded => FND_API.G_TRUE,
4748: p_msg_index => 1,
4749: p_msg_count => l_msg_count,
4750: p_msg_data => l_msg_data,

Line 4855: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4851: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4852: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4853: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4854: ,p_debug_mode IN VARCHAR2 :='N'
4855: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4856: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
4857: ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4858: ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
4859: ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()

Line 5247: PA_INTERFACE_UTILS_PUB.get_messages

5243: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
5244: END IF;
5245:
5246: IF l_msg_count = 1 THEN
5247: PA_INTERFACE_UTILS_PUB.get_messages
5248: (p_encoded => FND_API.G_TRUE,
5249: p_msg_index => 1,
5250: p_msg_count => l_msg_count,
5251: p_msg_data => l_msg_data,

Line 5307: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5306: ,p_debug_mode IN VARCHAR2 :='N'
5307: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5308: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
5309: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN paramter
5310: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5311: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5516: PA_INTERFACE_UTILS_PUB.get_messages

5512: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
5513: END IF;
5514:
5515: IF l_msg_count = 1 THEN
5516: PA_INTERFACE_UTILS_PUB.get_messages
5517: (p_encoded => FND_API.G_TRUE,
5518: p_msg_index => 1,
5519: p_msg_count => l_msg_count,
5520: p_msg_data => l_msg_data,