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 3202: IF ( p_action_in_tbl(i_actn).action_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

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

Line 3325: 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

3321: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3322: RAISE FND_API.G_EXC_ERROR;
3323: END IF;
3324:
3325: 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
3326:
3327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3328: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_NAME_NULL_ERROR') ;
3329: PA_UTILS.ADD_MESSAGE

Line 3394: 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 )

3390:
3391: -- Changed the direct initialization of local variables to select statement as values would differ in case of update or create bug 3651139
3392: IF (l_action = g_create) THEN
3393: SELECT
3394: 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 )
3395: , l_action_owner_id
3396: , 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 )
3397: , 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 )
3398: , NULL --l_completed_flag

Line 3396: , 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 )

3392: IF (l_action = g_create) THEN
3393: SELECT
3394: 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 )
3395: , l_action_owner_id
3396: , 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 )
3397: , 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 )
3398: , NULL --l_completed_flag
3399: , NULL --l_completion_date
3400: , NULL --l_element_version_id

Line 3397: , 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 )

3393: SELECT
3394: 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 )
3395: , l_action_owner_id
3396: , 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 )
3397: , 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 )
3398: , NULL --l_completed_flag
3399: , NULL --l_completion_date
3400: , NULL --l_element_version_id
3401: , NULL --l_proj_element_id

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

3399: , NULL --l_completion_date
3400: , NULL --l_element_version_id
3401: , NULL --l_proj_element_id
3402: , 1 --l_rec_ver_num_id
3403: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).description )
3404: , p_insert_or_update
3405: , 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 )
3406: , NULL --l_attribute_category
3407: , NULL --l_attribute1

Line 3405: , 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 )

3401: , NULL --l_proj_element_id
3402: , 1 --l_rec_ver_num_id
3403: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).description )
3404: , p_insert_or_update
3405: , 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 )
3406: , NULL --l_attribute_category
3407: , NULL --l_attribute1
3408: , NULL --l_attribute2
3409: , NULL --l_attribute3

Line 3454: 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 )

3450: , l_attribute15_tbl(i_actn)
3451: FROM DUAL;
3452: ELSE -- UPDATE
3453: SELECT
3454: 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 )
3455: , 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 )
3456: , 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 )
3457: , 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 )
3458: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag

Line 3455: , 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 )

3451: FROM DUAL;
3452: ELSE -- UPDATE
3453: SELECT
3454: 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 )
3455: , 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 )
3456: , 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 )
3457: , 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 )
3458: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag
3459: , 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 3456: , 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 )

3452: ELSE -- UPDATE
3453: SELECT
3454: 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 )
3455: , 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 )
3456: , 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 )
3457: , 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 )
3458: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag
3459: , 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
3460: , element_version_id

Line 3457: , 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 )

3453: SELECT
3454: 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 )
3455: , 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 )
3456: , 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 )
3457: , 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 )
3458: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag
3459: , 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
3460: , element_version_id
3461: , proj_element_id

Line 3459: , 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

3455: , 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 )
3456: , 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 )
3457: , 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 )
3458: , decode(action_status_code , 'DLVR_COMPLETED', 'Y', 'N') --l_completed_flag
3459: , 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
3460: , element_version_id
3461: , proj_element_id
3462: , NULL --l_rec_ver_num_id
3463: , 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 3463: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_action_in_tbl(i_actn).description )

3459: , 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
3460: , element_version_id
3461: , proj_element_id
3462: , NULL --l_rec_ver_num_id
3463: , decode(p_action_in_tbl(i_actn).description ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_action_in_tbl(i_actn).description )
3464: -- 3729250 removed p_insert_or_update passing , for update expected value is 'MODIFIED'
3465: -- because CR_UP_DLV_ACTIONS_IN_BULK procedure is expecting this value to be 'MODIFIED' , not 'UPDATE'
3466: , g_modified
3467: , 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 3467: , 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 )

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

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

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

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

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

Line 3537: 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

3533: l_fin_task_ref := NULL;
3534:
3535: -- if passed financial task id or reference is not passed , set it to null
3536:
3537: 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
3538: l_fin_task_id := p_action_in_tbl(i_actn).financial_task_id;
3539: END IF;
3540:
3541: 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 3541: 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

3537: 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
3538: l_fin_task_id := p_action_in_tbl(i_actn).financial_task_id;
3539: END IF;
3540:
3541: 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
3542: l_fin_task_ref := p_action_in_tbl(i_actn).financial_task_reference;
3543: END IF;
3544:
3545: -- if task reference / id is passed , validate passed reference with id

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

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

Line 3800: , 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 )

3796:
3797: IF (l_action = g_create) THEN -- added IF condition and else part of the code bug 3651139
3798: SELECT l_object_version_id
3799: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3800: , 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 )
3801: , 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
3802: , 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 )
3803: , 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 )
3804: , 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 3801: , 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

3797: IF (l_action = g_create) THEN -- added IF condition and else part of the code bug 3651139
3798: SELECT l_object_version_id
3799: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3800: , 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 )
3801: , 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
3802: , 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 )
3803: , 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 )
3804: , 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 )
3805: -- 3729250 , po_need_by_date should be populated with procurement action due date

Line 3802: , 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 )

3798: SELECT l_object_version_id
3799: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3800: , 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 )
3801: , 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
3802: , 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 )
3803: , 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 )
3804: , 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 )
3805: -- 3729250 , po_need_by_date should be populated with procurement action due date
3806: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date

Line 3803: , 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 )

3799: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3800: , 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 )
3801: , 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
3802: , 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 )
3803: , 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 )
3804: , 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 )
3805: -- 3729250 , po_need_by_date should be populated with procurement action due date
3806: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3807: , 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 3804: , 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 )

3800: , 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 )
3801: , 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
3802: , 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 )
3803: , 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 )
3804: , 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 )
3805: -- 3729250 , po_need_by_date should be populated with procurement action due date
3806: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3807: , 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
3808: , 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 3808: , 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 )

3804: , 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 )
3805: -- 3729250 , po_need_by_date should be populated with procurement action due date
3806: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3807: , 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
3808: , 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 )
3809: , 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 )
3810: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3811: , 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 )
3812: , 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 3809: , 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 )

3805: -- 3729250 , po_need_by_date should be populated with procurement action due date
3806: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3807: , 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
3808: , 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 )
3809: , 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 )
3810: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3811: , 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 )
3812: , 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 )
3813: , 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 3810: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )

3806: -- 3749462 changed from po_need_by_date to p_action_in_tbl(i_actn).due_date
3807: , 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
3808: , 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 )
3809: , 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 )
3810: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3811: , 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 )
3812: , 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 )
3813: , 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 )
3814: , 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 3811: , 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 )

3807: , 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
3808: , 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 )
3809: , 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 )
3810: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3811: , 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 )
3812: , 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 )
3813: , 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 )
3814: , 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 )
3815: , 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 3812: , 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 )

3808: , 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 )
3809: , 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 )
3810: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3811: , 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 )
3812: , 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 )
3813: , 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 )
3814: , 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 )
3815: , 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 )
3816: , 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 3813: , 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 )

3809: , 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 )
3810: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3811: , 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 )
3812: , 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 )
3813: , 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 )
3814: , 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 )
3815: , 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 )
3816: , 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 )
3817: , 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 3814: , 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 )

3810: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3811: , 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 )
3812: , 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 )
3813: , 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 )
3814: , 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 )
3815: , 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 )
3816: , 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 )
3817: , 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 )
3818: , 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 3815: , 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 )

3811: , 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 )
3812: , 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 )
3813: , 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 )
3814: , 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 )
3815: , 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 )
3816: , 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 )
3817: , 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 )
3818: , 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 )
3819: , 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 3816: , 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 )

3812: , 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 )
3813: , 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 )
3814: , 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 )
3815: , 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 )
3816: , 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 )
3817: , 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 )
3818: , 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 )
3819: , 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 )
3820: , 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 3817: , 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 )

3813: , 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 )
3814: , 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 )
3815: , 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 )
3816: , 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 )
3817: , 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 )
3818: , 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 )
3819: , 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 )
3820: , 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 )
3821: , 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 3818: , 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 )

3814: , 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 )
3815: , 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 )
3816: , 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 )
3817: , 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 )
3818: , 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 )
3819: , 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 )
3820: , 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 )
3821: , 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 )
3822: , 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 3819: , 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 )

3815: , 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 )
3816: , 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 )
3817: , 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 )
3818: , 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 )
3819: , 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 )
3820: , 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 )
3821: , 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 )
3822: , 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 )
3823: , 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 3820: , 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 )

3816: , 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 )
3817: , 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 )
3818: , 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 )
3819: , 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 )
3820: , 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 )
3821: , 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 )
3822: , 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 )
3823: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )
3824: INTO

Line 3821: , 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 )

3817: , 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 )
3818: , 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 )
3819: , 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 )
3820: , 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 )
3821: , 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 )
3822: , 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 )
3823: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )
3824: INTO
3825: l_dlv_req_action_tbl(i_proc).pa_deliverable_id

Line 3822: , 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 )

3818: , 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 )
3819: , 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 )
3820: , 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 )
3821: , 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 )
3822: , 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 )
3823: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )
3824: INTO
3825: l_dlv_req_action_tbl(i_proc).pa_deliverable_id
3826: , l_dlv_req_action_tbl(i_proc).pa_action_id

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

3819: , 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 )
3820: , 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 )
3821: , 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 )
3822: , 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 )
3823: , decode(p_action_in_tbl(i_actn).currency ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , null, p_action_in_tbl(i_actn).currency )
3824: INTO
3825: l_dlv_req_action_tbl(i_proc).pa_deliverable_id
3826: , l_dlv_req_action_tbl(i_proc).pa_action_id
3827: , l_dlv_req_action_tbl(i_proc).action_name

Line 3855: , 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 )

3851: ELSE -- UPDATE
3852:
3853: SELECT l_object_version_id
3854: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3855: , 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 )
3856: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3857: , 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 )
3858: , 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 )
3859: , 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 3857: , 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 )

3853: SELECT l_object_version_id
3854: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3855: , 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 )
3856: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3857: , 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 )
3858: , 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 )
3859: , 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 )
3860: -- 3729250 , po_need_by_date should be populated with procurement action due date
3861: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)

Line 3858: , 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 )

3854: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3855: , 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 )
3856: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3857: , 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 )
3858: , 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 )
3859: , 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 )
3860: -- 3729250 , po_need_by_date should be populated with procurement action due date
3861: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3862: , l_due_date_tbl(i_actn)

Line 3859: , 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 )

3855: , 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 )
3856: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3857: , 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 )
3858: , 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 )
3859: , 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 )
3860: -- 3729250 , po_need_by_date should be populated with procurement action due date
3861: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3862: , l_due_date_tbl(i_actn)
3863: , 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 3863: , 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 )

3859: , 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 )
3860: -- 3729250 , po_need_by_date should be populated with procurement action due date
3861: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3862: , l_due_date_tbl(i_actn)
3863: , 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 )
3864: , 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 )
3865: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3866: , 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 )
3867: , 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 3864: , 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 )

3860: -- 3729250 , po_need_by_date should be populated with procurement action due date
3861: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3862: , l_due_date_tbl(i_actn)
3863: , 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 )
3864: , 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 )
3865: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3866: , 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 )
3867: , 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 )
3868: , 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 3865: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )

3861: -- 3749462 changed from po_need_by_date to l_due_date_tbl(i_actn)
3862: , l_due_date_tbl(i_actn)
3863: , 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 )
3864: , 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 )
3865: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3866: , 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 )
3867: , 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 )
3868: , 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 )
3869: , 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 3866: , 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 )

3862: , l_due_date_tbl(i_actn)
3863: , 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 )
3864: , 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 )
3865: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3866: , 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 )
3867: , 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 )
3868: , 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 )
3869: , 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 )
3870: , 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 3867: , 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 )

3863: , 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 )
3864: , 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 )
3865: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3866: , 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 )
3867: , 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 )
3868: , 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 )
3869: , 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 )
3870: , 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 )
3871: , 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 3868: , 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 )

3864: , 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 )
3865: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3866: , 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 )
3867: , 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 )
3868: , 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 )
3869: , 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 )
3870: , 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 )
3871: , 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 )
3872: , 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 3869: , 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 )

3865: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3866: , 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 )
3867: , 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 )
3868: , 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 )
3869: , 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 )
3870: , 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 )
3871: , 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 )
3872: , 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 )
3873: , 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 3870: , 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 )

3866: , 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 )
3867: , 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 )
3868: , 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 )
3869: , 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 )
3870: , 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 )
3871: , 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 )
3872: , 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 )
3873: , 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 )
3874: , 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 3871: , 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 )

3867: , 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 )
3868: , 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 )
3869: , 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 )
3870: , 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 )
3871: , 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 )
3872: , 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 )
3873: , 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 )
3874: , 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 )
3875: , 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 3872: , 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 )

3868: , 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 )
3869: , 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 )
3870: , 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 )
3871: , 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 )
3872: , 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 )
3873: , 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 )
3874: , 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 )
3875: , 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 )
3876: , 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 3873: , 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 )

3869: , 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 )
3870: , 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 )
3871: , 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 )
3872: , 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 )
3873: , 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 )
3874: , 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 )
3875: , 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 )
3876: , 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 )
3877: , 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 3874: , 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 )

3870: , 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 )
3871: , 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 )
3872: , 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 )
3873: , 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 )
3874: , 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 )
3875: , 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 )
3876: , 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 )
3877: , 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 )
3878: , 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 3875: , 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 )

3871: , 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 )
3872: , 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 )
3873: , 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 )
3874: , 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 )
3875: , 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 )
3876: , 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 )
3877: , 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 )
3878: , 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 )
3879: INTO

Line 3876: , 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 )

3872: , 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 )
3873: , 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 )
3874: , 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 )
3875: , 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 )
3876: , 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 )
3877: , 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 )
3878: , 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 )
3879: INTO
3880: l_dlv_req_action_tbl(i_proc).pa_deliverable_id

Line 3877: , 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 )

3873: , 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 )
3874: , 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 )
3875: , 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 )
3876: , 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 )
3877: , 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 )
3878: , 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 )
3879: INTO
3880: l_dlv_req_action_tbl(i_proc).pa_deliverable_id
3881: , l_dlv_req_action_tbl(i_proc).pa_action_id

Line 3878: , 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 )

3874: , 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 )
3875: , 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 )
3876: , 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 )
3877: , 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 )
3878: , 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 )
3879: INTO
3880: l_dlv_req_action_tbl(i_proc).pa_deliverable_id
3881: , l_dlv_req_action_tbl(i_proc).pa_action_id
3882: , l_dlv_req_action_tbl(i_proc).action_name

Line 3929: , 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 )

3925:
3926: IF (l_action = g_create) THEN -- added IF condition and else part of the code bug 3651139
3927: SELECT l_object_version_id
3928: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3929: , 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 )
3930: , 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
3931: , 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 )
3932: , 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 )
3933: , 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 3930: , 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

3926: IF (l_action = g_create) THEN -- added IF condition and else part of the code bug 3651139
3927: SELECT l_object_version_id
3928: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3929: , 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 )
3930: , 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
3931: , 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 )
3932: , 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 )
3933: , 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 )
3934: , 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 3931: , 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 )

3927: SELECT l_object_version_id
3928: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3929: , 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 )
3930: , 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
3931: , 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 )
3932: , 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 )
3933: , 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 )
3934: , 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 )
3935: , 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 3932: , 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 )

3928: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3929: , 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 )
3930: , 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
3931: , 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 )
3932: , 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 )
3933: , 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 )
3934: , 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 )
3935: , 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 )
3936: , 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 3933: , 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 )

3929: , 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 )
3930: , 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
3931: , 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 )
3932: , 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 )
3933: , 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 )
3934: , 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 )
3935: , 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 )
3936: , 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 )
3937: -- 3729250 , expected_shipment_date should be populated with shipping action due date

Line 3934: , 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 )

3930: , 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
3931: , 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 )
3932: , 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 )
3933: , 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 )
3934: , 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 )
3935: , 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 )
3936: , 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 )
3937: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3938: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date

Line 3935: , 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 )

3931: , 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 )
3932: , 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 )
3933: , 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 )
3934: , 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 )
3935: , 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 )
3936: , 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 )
3937: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3938: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3939: , 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 3936: , 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 )

3932: , 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 )
3933: , 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 )
3934: , 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 )
3935: , 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 )
3936: , 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 )
3937: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3938: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3939: , 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
3940: , 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 3940: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )

3936: , 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 )
3937: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3938: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3939: , 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
3940: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3941: , 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 )
3942: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3943: , 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 )
3944: , 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 3941: , 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 )

3937: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3938: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3939: , 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
3940: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3941: , 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 )
3942: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3943: , 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 )
3944: , 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 )
3945: , 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 3942: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )

3938: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to p_action_in_tbl(i_actn).due_date
3939: , 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
3940: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3941: , 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 )
3942: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3943: , 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 )
3944: , 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 )
3945: , 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 )
3946: , 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 3943: , 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 )

3939: , 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
3940: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3941: , 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 )
3942: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3943: , 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 )
3944: , 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 )
3945: , 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 )
3946: , 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 )
3947: , 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 3944: , 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 )

3940: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).volume )
3941: , 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 )
3942: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3943: , 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 )
3944: , 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 )
3945: , 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 )
3946: , 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 )
3947: , 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 )
3948: , 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 3945: , 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 )

3941: , 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 )
3942: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3943: , 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 )
3944: , 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 )
3945: , 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 )
3946: , 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 )
3947: , 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 )
3948: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3949: INTO

Line 3946: , 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 )

3942: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).weight )
3943: , 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 )
3944: , 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 )
3945: , 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 )
3946: , 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 )
3947: , 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 )
3948: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3949: INTO
3950: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id

Line 3947: , 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 )

3943: , 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 )
3944: , 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 )
3945: , 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 )
3946: , 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 )
3947: , 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 )
3948: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3949: INTO
3950: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id
3951: , l_dlv_ship_action_tbl(i_ship).pa_action_id

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

3944: , 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 )
3945: , 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 )
3946: , 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 )
3947: , 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 )
3948: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , null, p_action_in_tbl(i_actn).quantity )
3949: INTO
3950: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id
3951: , l_dlv_ship_action_tbl(i_ship).pa_action_id
3952: , l_dlv_ship_action_tbl(i_ship).action_name

Line 3975: , 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 )

3971:
3972: ELSE -- UPDATE
3973: SELECT l_object_version_id
3974: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3975: , 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 )
3976: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3977: , 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 )
3978: , 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 )
3979: , 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 3977: , 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 )

3973: SELECT l_object_version_id
3974: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3975: , 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 )
3976: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3977: , 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 )
3978: , 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 )
3979: , 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 )
3980: , 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 )
3981: , 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 3978: , 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 )

3974: , l_actn_version_id -- 3651489 changed from l_action_id to l_actn_version_id, as element version id should be passed to oke
3975: , 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 )
3976: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3977: , 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 )
3978: , 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 )
3979: , 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 )
3980: , 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 )
3981: , 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 )
3982: , 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 3979: , 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 )

3975: , 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 )
3976: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3977: , 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 )
3978: , 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 )
3979: , 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 )
3980: , 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 )
3981: , 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 )
3982: , 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 )
3983: -- 3729250 , expected_shipment_date should be populated with shipping action due date

Line 3980: , 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 )

3976: , decode(l_fin_task_id_tbl(i_actn) ,NULL , task_id , l_fin_task_id_tbl(i_actn) ) -- for bug# 3749462
3977: , 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 )
3978: , 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 )
3979: , 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 )
3980: , 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 )
3981: , 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 )
3982: , 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 )
3983: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3984: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)

Line 3981: , 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 )

3977: , 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 )
3978: , 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 )
3979: , 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 )
3980: , 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 )
3981: , 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 )
3982: , 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 )
3983: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3984: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3985: , l_due_date_tbl(i_actn)

Line 3982: , 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 )

3978: , 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 )
3979: , 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 )
3980: , 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 )
3981: , 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 )
3982: , 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 )
3983: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3984: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3985: , l_due_date_tbl(i_actn)
3986: , 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 3986: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )

3982: , 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 )
3983: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3984: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3985: , l_due_date_tbl(i_actn)
3986: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3987: , 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 )
3988: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3989: , 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 )
3990: , 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 3987: , 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 )

3983: -- 3729250 , expected_shipment_date should be populated with shipping action due date
3984: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3985: , l_due_date_tbl(i_actn)
3986: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3987: , 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 )
3988: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3989: , 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 )
3990: , 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 )
3991: , 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 3988: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )

3984: -- 3749462 , changed from p_action_in_tbl(i_actn).expected_shipment_date to l_due_date_tbl(i_actn)
3985: , l_due_date_tbl(i_actn)
3986: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3987: , 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 )
3988: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3989: , 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 )
3990: , 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 )
3991: , 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 )
3992: , 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 3989: , 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 )

3985: , l_due_date_tbl(i_actn)
3986: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3987: , 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 )
3988: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3989: , 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 )
3990: , 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 )
3991: , 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 )
3992: , 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 )
3993: , 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 3990: , 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 )

3986: , decode(p_action_in_tbl(i_actn).volume ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , volume , p_action_in_tbl(i_actn).volume )
3987: , 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 )
3988: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3989: , 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 )
3990: , 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 )
3991: , 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 )
3992: , 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 )
3993: , 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 )
3994: , 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 3991: , 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 )

3987: , 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 )
3988: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3989: , 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 )
3990: , 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 )
3991: , 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 )
3992: , 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 )
3993: , 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 )
3994: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3995: INTO

Line 3992: , 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 )

3988: , decode(p_action_in_tbl(i_actn).weight ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , weight , p_action_in_tbl(i_actn).weight )
3989: , 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 )
3990: , 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 )
3991: , 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 )
3992: , 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 )
3993: , 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 )
3994: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3995: INTO
3996: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id

Line 3993: , 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 )

3989: , 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 )
3990: , 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 )
3991: , 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 )
3992: , 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 )
3993: , 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 )
3994: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3995: INTO
3996: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id
3997: , l_dlv_ship_action_tbl(i_ship).pa_action_id

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

3990: , 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 )
3991: , 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 )
3992: , 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 )
3993: , 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 )
3994: , decode(p_action_in_tbl(i_actn).quantity ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity , p_action_in_tbl(i_actn).quantity )
3995: INTO
3996: l_dlv_ship_action_tbl(i_ship).pa_deliverable_id
3997: , l_dlv_ship_action_tbl(i_ship).pa_action_id
3998: , l_dlv_ship_action_tbl(i_ship).action_name

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

4030: -- and so below condition was failing and oke data was not getting updated
4031: -- changed from p_action_in_tbl(i_actn).function_code to l_function_code_tbl(i_actn)
4032: ELSIF ( l_function_code_tbl(i_actn) = g_billing) THEN
4033:
4034: -- 4027500 Passing l_organization_name as PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR if update mode and p_organization_id
4035: -- is not passed
4036: -- else call C_org_name to derive organization_name from id
4037: 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
4038: l_organization_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

Line 4037: 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

4033:
4034: -- 4027500 Passing l_organization_name as PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR if update mode and p_organization_id
4035: -- is not passed
4036: -- else call C_org_name to derive organization_name from id
4037: 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
4038: l_organization_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
4039: ELSE
4040: OPEN C_org_name(p_action_in_tbl(i_actn).organization_id);
4041: FETCH C_org_name INTO l_organization_name;

Line 4038: l_organization_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

4034: -- 4027500 Passing l_organization_name as PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR if update mode and p_organization_id
4035: -- is not passed
4036: -- else call C_org_name to derive organization_name from id
4037: 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
4038: l_organization_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
4039: ELSE
4040: OPEN C_org_name(p_action_in_tbl(i_actn).organization_id);
4041: FETCH C_org_name INTO l_organization_name;
4042: IF (C_org_name%rowcount = 0 ) THEN

Line 4073: p_action_in_tbl(i_actn).pm_event_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4069:
4070: -- Bug 7759051
4071: IF ((l_action <> g_create) AND
4072: ((p_action_in_tbl(i_actn).pm_event_reference IS NOT NULL AND
4073: p_action_in_tbl(i_actn).pm_event_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4074: (l_fin_task_num_tbl(i_actn) IS NOT NULL AND
4075: l_fin_task_num_tbl(i_actn) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4076: (p_action_in_tbl(i_actn).event_type IS NOT NULL AND
4077: p_action_in_tbl(i_actn).event_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4075: l_fin_task_num_tbl(i_actn) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4071: IF ((l_action <> g_create) AND
4072: ((p_action_in_tbl(i_actn).pm_event_reference IS NOT NULL AND
4073: p_action_in_tbl(i_actn).pm_event_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4074: (l_fin_task_num_tbl(i_actn) IS NOT NULL AND
4075: l_fin_task_num_tbl(i_actn) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4076: (p_action_in_tbl(i_actn).event_type IS NOT NULL AND
4077: p_action_in_tbl(i_actn).event_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4078: (p_action_in_tbl(i_actn).description IS NOT NULL AND
4079: p_action_in_tbl(i_actn).description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4077: p_action_in_tbl(i_actn).event_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4073: p_action_in_tbl(i_actn).pm_event_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4074: (l_fin_task_num_tbl(i_actn) IS NOT NULL AND
4075: l_fin_task_num_tbl(i_actn) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4076: (p_action_in_tbl(i_actn).event_type IS NOT NULL AND
4077: p_action_in_tbl(i_actn).event_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4078: (p_action_in_tbl(i_actn).description IS NOT NULL AND
4079: p_action_in_tbl(i_actn).description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4080: (p_action_in_tbl(i_actn).bill_hold_flag IS NOT NULL AND
4081: p_action_in_tbl(i_actn).bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4079: p_action_in_tbl(i_actn).description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4075: l_fin_task_num_tbl(i_actn) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4076: (p_action_in_tbl(i_actn).event_type IS NOT NULL AND
4077: p_action_in_tbl(i_actn).event_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4078: (p_action_in_tbl(i_actn).description IS NOT NULL AND
4079: p_action_in_tbl(i_actn).description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4080: (p_action_in_tbl(i_actn).bill_hold_flag IS NOT NULL AND
4081: p_action_in_tbl(i_actn).bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4082: (l_organization_name IS NOT NULL AND
4083: l_organization_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4081: p_action_in_tbl(i_actn).bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4077: p_action_in_tbl(i_actn).event_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4078: (p_action_in_tbl(i_actn).description IS NOT NULL AND
4079: p_action_in_tbl(i_actn).description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4080: (p_action_in_tbl(i_actn).bill_hold_flag IS NOT NULL AND
4081: p_action_in_tbl(i_actn).bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4082: (l_organization_name IS NOT NULL AND
4083: l_organization_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4084: (p_action_in_tbl(i_actn).quantity IS NOT NULL AND
4085: p_action_in_tbl(i_actn).quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

Line 4083: l_organization_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4079: p_action_in_tbl(i_actn).description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4080: (p_action_in_tbl(i_actn).bill_hold_flag IS NOT NULL AND
4081: p_action_in_tbl(i_actn).bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4082: (l_organization_name IS NOT NULL AND
4083: l_organization_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4084: (p_action_in_tbl(i_actn).quantity IS NOT NULL AND
4085: p_action_in_tbl(i_actn).quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4086: (p_action_in_tbl(i_actn).uom_code IS NOT NULL AND
4087: p_action_in_tbl(i_actn).uom_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4085: p_action_in_tbl(i_actn).quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

4081: p_action_in_tbl(i_actn).bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4082: (l_organization_name IS NOT NULL AND
4083: l_organization_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4084: (p_action_in_tbl(i_actn).quantity IS NOT NULL AND
4085: p_action_in_tbl(i_actn).quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4086: (p_action_in_tbl(i_actn).uom_code IS NOT NULL AND
4087: p_action_in_tbl(i_actn).uom_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4088: (p_action_in_tbl(i_actn).unit_price IS NOT NULL AND
4089: p_action_in_tbl(i_actn).unit_price = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

Line 4087: p_action_in_tbl(i_actn).uom_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4083: l_organization_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4084: (p_action_in_tbl(i_actn).quantity IS NOT NULL AND
4085: p_action_in_tbl(i_actn).quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4086: (p_action_in_tbl(i_actn).uom_code IS NOT NULL AND
4087: p_action_in_tbl(i_actn).uom_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4088: (p_action_in_tbl(i_actn).unit_price IS NOT NULL AND
4089: p_action_in_tbl(i_actn).unit_price = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4090: (p_action_in_tbl(i_actn).currency IS NOT NULL AND
4091: p_action_in_tbl(i_actn).currency = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4089: p_action_in_tbl(i_actn).unit_price = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

4085: p_action_in_tbl(i_actn).quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4086: (p_action_in_tbl(i_actn).uom_code IS NOT NULL AND
4087: p_action_in_tbl(i_actn).uom_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4088: (p_action_in_tbl(i_actn).unit_price IS NOT NULL AND
4089: p_action_in_tbl(i_actn).unit_price = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4090: (p_action_in_tbl(i_actn).currency IS NOT NULL AND
4091: p_action_in_tbl(i_actn).currency = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4092: (p_action_in_tbl(i_actn).invoice_amount IS NOT NULL AND
4093: p_action_in_tbl(i_actn).invoice_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

Line 4091: p_action_in_tbl(i_actn).currency = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4087: p_action_in_tbl(i_actn).uom_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4088: (p_action_in_tbl(i_actn).unit_price IS NOT NULL AND
4089: p_action_in_tbl(i_actn).unit_price = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4090: (p_action_in_tbl(i_actn).currency IS NOT NULL AND
4091: p_action_in_tbl(i_actn).currency = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4092: (p_action_in_tbl(i_actn).invoice_amount IS NOT NULL AND
4093: p_action_in_tbl(i_actn).invoice_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4094: (p_action_in_tbl(i_actn).revenue_amount IS NOT NULL AND
4095: p_action_in_tbl(i_actn).revenue_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

Line 4093: p_action_in_tbl(i_actn).invoice_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

4089: p_action_in_tbl(i_actn).unit_price = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4090: (p_action_in_tbl(i_actn).currency IS NOT NULL AND
4091: p_action_in_tbl(i_actn).currency = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4092: (p_action_in_tbl(i_actn).invoice_amount IS NOT NULL AND
4093: p_action_in_tbl(i_actn).invoice_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4094: (p_action_in_tbl(i_actn).revenue_amount IS NOT NULL AND
4095: p_action_in_tbl(i_actn).revenue_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4096: (p_action_in_tbl(i_actn).project_rate_type IS NOT NULL AND
4097: p_action_in_tbl(i_actn).project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4095: p_action_in_tbl(i_actn).revenue_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

4091: p_action_in_tbl(i_actn).currency = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4092: (p_action_in_tbl(i_actn).invoice_amount IS NOT NULL AND
4093: p_action_in_tbl(i_actn).invoice_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4094: (p_action_in_tbl(i_actn).revenue_amount IS NOT NULL AND
4095: p_action_in_tbl(i_actn).revenue_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4096: (p_action_in_tbl(i_actn).project_rate_type IS NOT NULL AND
4097: p_action_in_tbl(i_actn).project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4098: (p_action_in_tbl(i_actn).project_rate_date IS NOT NULL AND
4099: p_action_in_tbl(i_actn).project_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND

Line 4097: p_action_in_tbl(i_actn).project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4093: p_action_in_tbl(i_actn).invoice_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4094: (p_action_in_tbl(i_actn).revenue_amount IS NOT NULL AND
4095: p_action_in_tbl(i_actn).revenue_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4096: (p_action_in_tbl(i_actn).project_rate_type IS NOT NULL AND
4097: p_action_in_tbl(i_actn).project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4098: (p_action_in_tbl(i_actn).project_rate_date IS NOT NULL AND
4099: p_action_in_tbl(i_actn).project_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4100: (p_action_in_tbl(i_actn).project_rate IS NOT NULL AND
4101: p_action_in_tbl(i_actn).project_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

Line 4099: p_action_in_tbl(i_actn).project_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND

4095: p_action_in_tbl(i_actn).revenue_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4096: (p_action_in_tbl(i_actn).project_rate_type IS NOT NULL AND
4097: p_action_in_tbl(i_actn).project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4098: (p_action_in_tbl(i_actn).project_rate_date IS NOT NULL AND
4099: p_action_in_tbl(i_actn).project_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4100: (p_action_in_tbl(i_actn).project_rate IS NOT NULL AND
4101: p_action_in_tbl(i_actn).project_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4102: (p_action_in_tbl(i_actn).project_functional_rate_type IS NOT NULL AND
4103: p_action_in_tbl(i_actn).project_functional_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4101: p_action_in_tbl(i_actn).project_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

4097: p_action_in_tbl(i_actn).project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4098: (p_action_in_tbl(i_actn).project_rate_date IS NOT NULL AND
4099: p_action_in_tbl(i_actn).project_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4100: (p_action_in_tbl(i_actn).project_rate IS NOT NULL AND
4101: p_action_in_tbl(i_actn).project_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4102: (p_action_in_tbl(i_actn).project_functional_rate_type IS NOT NULL AND
4103: p_action_in_tbl(i_actn).project_functional_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4104: (p_action_in_tbl(i_actn).project_functional_rate_date IS NOT NULL AND
4105: p_action_in_tbl(i_actn).project_functional_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND

Line 4103: p_action_in_tbl(i_actn).project_functional_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4099: p_action_in_tbl(i_actn).project_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4100: (p_action_in_tbl(i_actn).project_rate IS NOT NULL AND
4101: p_action_in_tbl(i_actn).project_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4102: (p_action_in_tbl(i_actn).project_functional_rate_type IS NOT NULL AND
4103: p_action_in_tbl(i_actn).project_functional_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4104: (p_action_in_tbl(i_actn).project_functional_rate_date IS NOT NULL AND
4105: p_action_in_tbl(i_actn).project_functional_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4106: (p_action_in_tbl(i_actn).project_functional_rate IS NOT NULL AND
4107: p_action_in_tbl(i_actn).project_functional_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

Line 4105: p_action_in_tbl(i_actn).project_functional_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND

4101: p_action_in_tbl(i_actn).project_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4102: (p_action_in_tbl(i_actn).project_functional_rate_type IS NOT NULL AND
4103: p_action_in_tbl(i_actn).project_functional_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4104: (p_action_in_tbl(i_actn).project_functional_rate_date IS NOT NULL AND
4105: p_action_in_tbl(i_actn).project_functional_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4106: (p_action_in_tbl(i_actn).project_functional_rate IS NOT NULL AND
4107: p_action_in_tbl(i_actn).project_functional_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4108: (p_action_in_tbl(i_actn).funding_rate_type IS NOT NULL AND
4109: p_action_in_tbl(i_actn).funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 4107: p_action_in_tbl(i_actn).project_functional_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

4103: p_action_in_tbl(i_actn).project_functional_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4104: (p_action_in_tbl(i_actn).project_functional_rate_date IS NOT NULL AND
4105: p_action_in_tbl(i_actn).project_functional_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4106: (p_action_in_tbl(i_actn).project_functional_rate IS NOT NULL AND
4107: p_action_in_tbl(i_actn).project_functional_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4108: (p_action_in_tbl(i_actn).funding_rate_type IS NOT NULL AND
4109: p_action_in_tbl(i_actn).funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4110: (p_action_in_tbl(i_actn).funding_rate_date IS NOT NULL AND
4111: p_action_in_tbl(i_actn).funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND

Line 4109: p_action_in_tbl(i_actn).funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

4105: p_action_in_tbl(i_actn).project_functional_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4106: (p_action_in_tbl(i_actn).project_functional_rate IS NOT NULL AND
4107: p_action_in_tbl(i_actn).project_functional_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4108: (p_action_in_tbl(i_actn).funding_rate_type IS NOT NULL AND
4109: p_action_in_tbl(i_actn).funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4110: (p_action_in_tbl(i_actn).funding_rate_date IS NOT NULL AND
4111: p_action_in_tbl(i_actn).funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4112: (p_action_in_tbl(i_actn).funding_rate IS NOT NULL AND
4113: p_action_in_tbl(i_actn).funding_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

Line 4111: p_action_in_tbl(i_actn).funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND

4107: p_action_in_tbl(i_actn).project_functional_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4108: (p_action_in_tbl(i_actn).funding_rate_type IS NOT NULL AND
4109: p_action_in_tbl(i_actn).funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4110: (p_action_in_tbl(i_actn).funding_rate_date IS NOT NULL AND
4111: p_action_in_tbl(i_actn).funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4112: (p_action_in_tbl(i_actn).funding_rate IS NOT NULL AND
4113: p_action_in_tbl(i_actn).funding_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
4114: )THEN
4115: -- In Update context, if none of the billing event related parameters are passed,

Line 4113: p_action_in_tbl(i_actn).funding_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

4109: p_action_in_tbl(i_actn).funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
4110: (p_action_in_tbl(i_actn).funding_rate_date IS NOT NULL AND
4111: p_action_in_tbl(i_actn).funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
4112: (p_action_in_tbl(i_actn).funding_rate IS NOT NULL AND
4113: p_action_in_tbl(i_actn).funding_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
4114: )THEN
4115: -- In Update context, if none of the billing event related parameters are passed,
4116: -- then it is not required to call pa_event_pub.update_event
4117: NULL;

Line 4360: PA_INTERFACE_UTILS_PUB.get_messages

4356: l_msg_count := FND_MSG_PUB.count_msg;
4357:
4358: IF l_msg_count = 1 AND x_msg_data IS NULL
4359: THEN
4360: PA_INTERFACE_UTILS_PUB.get_messages
4361: (p_encoded => FND_API.G_FALSE,
4362: p_msg_index => 1,
4363: p_msg_count => x_msg_count,
4364: p_msg_data => l_msg_data,

Line 4389: PA_INTERFACE_UTILS_PUB.get_messages

4385: l_msg_count := FND_MSG_PUB.count_msg;
4386:
4387: IF l_msg_count = 1 AND x_msg_data IS NULL
4388: THEN
4389: PA_INTERFACE_UTILS_PUB.get_messages
4390: (p_encoded => FND_API.G_FALSE,
4391: p_msg_index => 1,
4392: p_msg_count => x_msg_count,
4393: p_msg_data => l_msg_data,

Line 4815: PA_INTERFACE_UTILS_PUB.get_messages

4811: CLOSE c_valid_project_number_entry ;
4812: END IF ;
4813:
4814: IF l_msg_count >= 1 THEN
4815: PA_INTERFACE_UTILS_PUB.get_messages
4816: (p_encoded => FND_API.G_TRUE,
4817: p_msg_index => 1,
4818: p_msg_count => l_msg_count,
4819: p_msg_data => l_msg_data,

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

4920: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4921: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4922: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4923: ,p_debug_mode IN VARCHAR2 :='N'
4924: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4925: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
4926: ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4927: ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
4928: ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()

Line 5316: PA_INTERFACE_UTILS_PUB.get_messages

5312: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
5313: END IF;
5314:
5315: IF l_msg_count = 1 THEN
5316: PA_INTERFACE_UTILS_PUB.get_messages
5317: (p_encoded => FND_API.G_TRUE,
5318: p_msg_index => 1,
5319: p_msg_count => l_msg_count,
5320: p_msg_data => l_msg_data,

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

5372: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5373: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5375: ,p_debug_mode IN VARCHAR2 :='N'
5376: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5377: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
5378: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN paramter
5379: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5380: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5585: PA_INTERFACE_UTILS_PUB.get_messages

5581: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
5582: END IF;
5583:
5584: IF l_msg_count = 1 THEN
5585: PA_INTERFACE_UTILS_PUB.get_messages
5586: (p_encoded => FND_API.G_TRUE,
5587: p_msg_index => 1,
5588: p_msg_count => l_msg_count,
5589: p_msg_data => l_msg_data,