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_DELIVERABLE_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 124: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */

120: , p_item_description IN VARCHAR2 := NULL
121: , p_unit_price IN NUMBER := NULL
122: , p_unit_number IN VARCHAR2 := NULL
123: , p_currency_code IN VARCHAR2 := NULL
124: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */
125: , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
126: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
127: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
128: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 194: IF p_dlvr_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

190: END IF;
191:
192: /*==============3435905 : FP M : Deliverables Changes For AMG - START ==============================*/
193:
194: IF p_dlvr_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
195: l_dlvr_description := NULL;
196: ELSE
197: l_dlvr_description := p_dlvr_description;
198: END IF;

Line 200: IF p_dlvr_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

196: ELSE
197: l_dlvr_description := p_dlvr_description;
198: END IF;
199:
200: IF p_dlvr_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
201: l_dlvr_owner_id := NULL;
202: ELSE
203: l_dlvr_owner_id := p_dlvr_owner_id;
204: END IF;

Line 206: IF p_carrying_out_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

202: ELSE
203: l_dlvr_owner_id := p_dlvr_owner_id;
204: END IF;
205:
206: IF p_carrying_out_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
207: l_carrying_out_org_id := NULL;
208: ELSE
209: l_carrying_out_org_id := p_carrying_out_org_id;
210: END IF;

Line 212: IF p_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

208: ELSE
209: l_carrying_out_org_id := p_carrying_out_org_id;
210: END IF;
211:
212: IF p_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
213: l_status_code := NULL;
214: ELSE
215: l_status_code := p_status_code;
216: END IF;

Line 218: IF p_progress_weight = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

214: ELSE
215: l_status_code := p_status_code;
216: END IF;
217:
218: IF p_progress_weight = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
219: l_progress_weight := NULL;
220: ELSE
221: l_progress_weight := p_progress_weight;
222: END IF;

Line 224: IF p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

220: ELSE
221: l_progress_weight := p_progress_weight;
222: END IF;
223:
224: IF p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
225: l_scheduled_finish_date := NULL;
226: ELSE
227: l_scheduled_finish_date := p_scheduled_finish_date;
228: END IF;

Line 230: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

226: ELSE
227: l_scheduled_finish_date := p_scheduled_finish_date;
228: END IF;
229:
230: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
231: l_actual_finish_date := NULL;
232: ELSE
233: l_actual_finish_date := p_actual_finish_date;
234: END IF;

Line 237: IF (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

233: l_actual_finish_date := p_actual_finish_date;
234: END IF;
235:
236: -- Fetching Task Name , Project Name to use as token in Error Messages.
237: IF (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
238: SELECT name INTO l_task_number
239: FROM Pa_Proj_Elements
240: WHERE proj_element_id = p_task_id;
241: ELSE

Line 599: IF p_item_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

595: AND project_id = p_project_id;
596:
597: -- 3630378 Added below code for item information
598:
599: IF p_item_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
600: l_item_id := NULL;
601: ELSE
602: l_item_id := p_item_id;
603: END IF;

Line 605: IF p_inventory_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

601: ELSE
602: l_item_id := p_item_id;
603: END IF;
604:
605: IF p_inventory_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
606: l_inventory_org_id := NULL;
607: ELSE
608: l_inventory_org_id := p_inventory_org_id;
609: END IF;

Line 621: IF p_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

617: ,x_msg_data => l_msg_data
618: ,x_msg_count => l_msg_count
619: );
620:
621: IF p_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
622: l_quantity := NULL;
623: ELSE
624: l_quantity := p_quantity;
625: END IF;

Line 627: IF p_uom_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

623: ELSE
624: l_quantity := p_quantity;
625: END IF;
626:
627: IF p_uom_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
628: l_uom_code := NULL;
629: ELSE
630: l_uom_code := p_uom_code;
631: END IF;

Line 633: IF p_unit_price = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

629: ELSE
630: l_uom_code := p_uom_code;
631: END IF;
632:
633: IF p_unit_price = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
634: l_unit_price := NULL;
635: ELSE
636: l_unit_price := p_unit_price;
637: END IF;

Line 639: IF p_unit_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

635: ELSE
636: l_unit_price := p_unit_price;
637: END IF;
638:
639: IF p_unit_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
640: l_unit_number := NULL;
641: ELSE
642: l_unit_number := p_unit_number;
643: END IF;

Line 645: IF p_currency_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

641: ELSE
642: l_unit_number := p_unit_number;
643: END IF;
644:
645: IF p_currency_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
646: l_currency_code := NULL;
647: ELSE
648: l_currency_code := p_currency_code;
649: END IF;

Line 723: Pa_Interface_Utils_Pub.get_messages

719: END IF;
720:
721: IF l_msg_count = 1 AND x_msg_data IS NULL
722: THEN
723: Pa_Interface_Utils_Pub.get_messages
724: ( p_encoded => Fnd_Api.G_TRUE
725: , p_msg_index => 1
726: , p_msg_count => l_msg_count
727: , p_msg_data => l_msg_data

Line 904: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */

900: , p_unit_price IN NUMBER := NULL
901: , p_unit_number IN VARCHAR2 := NULL
902: , p_currency_code IN VARCHAR2 := NULL
903: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
904: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */
905: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
906: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
907: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
908: )

Line 951: decode( p_dlvr_name , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, element_name, p_dlvr_name) element_name

947: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE ;
948: l_item_dlv VARCHAR2(1) ;
949:
950: Cursor C_dlvr IS SELECT
951: decode( p_dlvr_name , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, element_name, p_dlvr_name) element_name
952: , decode( p_dlvr_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description , p_dlvr_description) description
953: , decode( p_dlvr_owner_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, manager_person_id, p_dlvr_owner_id) manager_person_id
954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later
955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code

Line 952: , decode( p_dlvr_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description , p_dlvr_description) description

948: l_item_dlv VARCHAR2(1) ;
949:
950: Cursor C_dlvr IS SELECT
951: decode( p_dlvr_name , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, element_name, p_dlvr_name) element_name
952: , decode( p_dlvr_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description , p_dlvr_description) description
953: , decode( p_dlvr_owner_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, manager_person_id, p_dlvr_owner_id) manager_person_id
954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later
955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code
956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id

Line 953: , decode( p_dlvr_owner_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, manager_person_id, p_dlvr_owner_id) manager_person_id

949:
950: Cursor C_dlvr IS SELECT
951: decode( p_dlvr_name , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, element_name, p_dlvr_name) element_name
952: , decode( p_dlvr_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description , p_dlvr_description) description
953: , decode( p_dlvr_owner_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, manager_person_id, p_dlvr_owner_id) manager_person_id
954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later
955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code
956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id
957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight

Line 954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later

950: Cursor C_dlvr IS SELECT
951: decode( p_dlvr_name , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, element_name, p_dlvr_name) element_name
952: , decode( p_dlvr_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description , p_dlvr_description) description
953: , decode( p_dlvr_owner_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, manager_person_id, p_dlvr_owner_id) manager_person_id
954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later
955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code
956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id
957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight
958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date

Line 955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code

951: decode( p_dlvr_name , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, element_name, p_dlvr_name) element_name
952: , decode( p_dlvr_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description , p_dlvr_description) description
953: , decode( p_dlvr_owner_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, manager_person_id, p_dlvr_owner_id) manager_person_id
954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later
955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code
956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id
957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight
958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date
959: , decode( p_actual_finish_date , PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,completion_date, p_actual_finish_date) completion_date

Line 956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id

952: , decode( p_dlvr_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description , p_dlvr_description) description
953: , decode( p_dlvr_owner_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, manager_person_id, p_dlvr_owner_id) manager_person_id
954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later
955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code
956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id
957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight
958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date
959: , decode( p_actual_finish_date , PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,completion_date, p_actual_finish_date) completion_date
960: , decode( p_task_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_task_id) task_id -- added bug 3651538

Line 957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight

953: , decode( p_dlvr_owner_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, manager_person_id, p_dlvr_owner_id) manager_person_id
954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later
955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code
956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id
957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight
958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date
959: , decode( p_actual_finish_date , PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,completion_date, p_actual_finish_date) completion_date
960: , decode( p_task_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_task_id) task_id -- added bug 3651538
961: , decode( p_deliverable_reference, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, pm_source_reference, p_deliverable_reference) pm_source_reference -- added for bug# 3749447

Line 958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date

954: , decode( p_carrying_out_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_carrying_out_org_id) carrying_out_org_id -- to be derived later
955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code
956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id
957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight
958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date
959: , decode( p_actual_finish_date , PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,completion_date, p_actual_finish_date) completion_date
960: , decode( p_task_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_task_id) task_id -- added bug 3651538
961: , decode( p_deliverable_reference, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, pm_source_reference, p_deliverable_reference) pm_source_reference -- added for bug# 3749447
962: FROM pa_deliverables_v

Line 959: , decode( p_actual_finish_date , PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,completion_date, p_actual_finish_date) completion_date

955: , decode( p_status_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,status_code , p_status_code) status_code
956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id
957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight
958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date
959: , decode( p_actual_finish_date , PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,completion_date, p_actual_finish_date) completion_date
960: , decode( p_task_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_task_id) task_id -- added bug 3651538
961: , decode( p_deliverable_reference, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, pm_source_reference, p_deliverable_reference) pm_source_reference -- added for bug# 3749447
962: FROM pa_deliverables_v
963: WHERE element_version_id = p_dlvr_version_id;

Line 960: , decode( p_task_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_task_id) task_id -- added bug 3651538

956: , decode( p_dlvr_type_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, dlvr_type_id, p_dlvr_type_id) dlvr_type_id
957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight
958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date
959: , decode( p_actual_finish_date , PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,completion_date, p_actual_finish_date) completion_date
960: , decode( p_task_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_task_id) task_id -- added bug 3651538
961: , decode( p_deliverable_reference, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, pm_source_reference, p_deliverable_reference) pm_source_reference -- added for bug# 3749447
962: FROM pa_deliverables_v
963: WHERE element_version_id = p_dlvr_version_id;
964:

Line 961: , decode( p_deliverable_reference, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, pm_source_reference, p_deliverable_reference) pm_source_reference -- added for bug# 3749447

957: , decode( p_progress_weight , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, progress_weight, p_progress_weight) progress_weight
958: , decode( p_scheduled_finish_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,due_date , p_scheduled_finish_date) due_date
959: , decode( p_actual_finish_date , PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,completion_date, p_actual_finish_date) completion_date
960: , decode( p_task_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, null , p_task_id) task_id -- added bug 3651538
961: , decode( p_deliverable_reference, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, pm_source_reference, p_deliverable_reference) pm_source_reference -- added for bug# 3749447
962: FROM pa_deliverables_v
963: WHERE element_version_id = p_dlvr_version_id;
964:
965: Cursor C_oke IS SELECT

Line 966: decode( p_item_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , item_id, p_item_id) item_id

962: FROM pa_deliverables_v
963: WHERE element_version_id = p_dlvr_version_id;
964:
965: Cursor C_oke IS SELECT
966: decode( p_item_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , item_id, p_item_id) item_id
967: , decode( p_inventory_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , inventory_org_id, p_inventory_org_id) inventory_org_id
968: , decode( p_quantity , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity, p_quantity) quantity
969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code
970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description

Line 967: , decode( p_inventory_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , inventory_org_id, p_inventory_org_id) inventory_org_id

963: WHERE element_version_id = p_dlvr_version_id;
964:
965: Cursor C_oke IS SELECT
966: decode( p_item_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , item_id, p_item_id) item_id
967: , decode( p_inventory_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , inventory_org_id, p_inventory_org_id) inventory_org_id
968: , decode( p_quantity , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity, p_quantity) quantity
969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code
970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description
971: , decode( p_unit_price , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price, p_unit_price) unit_price

Line 968: , decode( p_quantity , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity, p_quantity) quantity

964:
965: Cursor C_oke IS SELECT
966: decode( p_item_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , item_id, p_item_id) item_id
967: , decode( p_inventory_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , inventory_org_id, p_inventory_org_id) inventory_org_id
968: , decode( p_quantity , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity, p_quantity) quantity
969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code
970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description
971: , decode( p_unit_price , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price, p_unit_price) unit_price
972: , decode( p_unit_number , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , unit_number, p_unit_number) unit_number -- 3749447 changed from G_PA_MISS_NUM to G_PA_MISS_CHAR

Line 969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code

965: Cursor C_oke IS SELECT
966: decode( p_item_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , item_id, p_item_id) item_id
967: , decode( p_inventory_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , inventory_org_id, p_inventory_org_id) inventory_org_id
968: , decode( p_quantity , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity, p_quantity) quantity
969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code
970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description
971: , decode( p_unit_price , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price, p_unit_price) unit_price
972: , decode( p_unit_number , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , unit_number, p_unit_number) unit_number -- 3749447 changed from G_PA_MISS_NUM to G_PA_MISS_CHAR
973: , decode( p_currency_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code, p_currency_code) currency_code

Line 970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description

966: decode( p_item_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , item_id, p_item_id) item_id
967: , decode( p_inventory_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , inventory_org_id, p_inventory_org_id) inventory_org_id
968: , decode( p_quantity , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity, p_quantity) quantity
969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code
970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description
971: , decode( p_unit_price , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price, p_unit_price) unit_price
972: , decode( p_unit_number , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , unit_number, p_unit_number) unit_number -- 3749447 changed from G_PA_MISS_NUM to G_PA_MISS_CHAR
973: , decode( p_currency_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code, p_currency_code) currency_code
974: FROM oke_deliverables_vl

Line 971: , decode( p_unit_price , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price, p_unit_price) unit_price

967: , decode( p_inventory_org_id , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , inventory_org_id, p_inventory_org_id) inventory_org_id
968: , decode( p_quantity , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity, p_quantity) quantity
969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code
970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description
971: , decode( p_unit_price , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price, p_unit_price) unit_price
972: , decode( p_unit_number , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , unit_number, p_unit_number) unit_number -- 3749447 changed from G_PA_MISS_NUM to G_PA_MISS_CHAR
973: , decode( p_currency_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code, p_currency_code) currency_code
974: FROM oke_deliverables_vl
975: WHERE source_deliverable_id = p_dlvr_version_id; -- 3749447 changed where clause condition from deliverable_number = p_dlvr_number to use deliverable ver id

Line 972: , decode( p_unit_number , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , unit_number, p_unit_number) unit_number -- 3749447 changed from G_PA_MISS_NUM to G_PA_MISS_CHAR

968: , decode( p_quantity , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , quantity, p_quantity) quantity
969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code
970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description
971: , decode( p_unit_price , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price, p_unit_price) unit_price
972: , decode( p_unit_number , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , unit_number, p_unit_number) unit_number -- 3749447 changed from G_PA_MISS_NUM to G_PA_MISS_CHAR
973: , decode( p_currency_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code, p_currency_code) currency_code
974: FROM oke_deliverables_vl
975: WHERE source_deliverable_id = p_dlvr_version_id; -- 3749447 changed where clause condition from deliverable_number = p_dlvr_number to use deliverable ver id
976:

Line 973: , decode( p_currency_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code, p_currency_code) currency_code

969: , decode( p_uom_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , uom_code, p_uom_code) uom_code
970: , decode( p_item_description , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , description, p_item_description) description
971: , decode( p_unit_price , PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , unit_price, p_unit_price) unit_price
972: , decode( p_unit_number , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , unit_number, p_unit_number) unit_number -- 3749447 changed from G_PA_MISS_NUM to G_PA_MISS_CHAR
973: , decode( p_currency_code , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR , currency_code, p_currency_code) currency_code
974: FROM oke_deliverables_vl
975: WHERE source_deliverable_id = p_dlvr_version_id; -- 3749447 changed where clause condition from deliverable_number = p_dlvr_number to use deliverable ver id
976:
977: l_dlv_rec oke_amg_grp.dlv_rec_type;

Line 1426: Pa_Interface_Utils_Pub.get_messages

1422: END IF;
1423:
1424: IF l_msg_count = 1 AND x_msg_data IS NULL
1425: THEN
1426: Pa_Interface_Utils_Pub.get_messages
1427: ( p_encoded => Fnd_Api.G_TRUE
1428: , p_msg_index => 1
1429: , p_msg_count => l_msg_count
1430: , p_msg_data => l_msg_data

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

1523: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1524: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1525: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1526: ,p_debug_mode IN VARCHAR2 :='N'
1527: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1528: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
1529: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

Line 1651: PA_INTERFACE_UTILS_PUB.get_messages

1647: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1648: END IF;
1649:
1650: IF l_msg_count = 1 THEN
1651: PA_INTERFACE_UTILS_PUB.get_messages
1652: (p_encoded => FND_API.G_TRUE,
1653: p_msg_index => 1,
1654: p_msg_count => l_msg_count,
1655: p_msg_data => l_msg_data,

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

1716: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1717: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1718: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1719: ,p_debug_mode IN VARCHAR2 :='N'
1720: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1721: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1722: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1723: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1724: ,p_dlv_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 1811: PA_INTERFACE_UTILS_PUB.get_messages

1807:
1808: j := j+1 ;
1809:
1810:
1811: PA_INTERFACE_UTILS_PUB.get_messages
1812: (p_encoded => FND_API.G_FALSE, -- Get the encoded message.
1813: p_msg_index => 1, -- Get the message at index 1.
1814: p_data => l_enc_msg_data,
1815: p_msg_index_out => l_msg_index_out);

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

1930: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1931: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1932: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1933: ,p_debug_mode IN VARCHAR2 :='N'
1934: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1935: ,p_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1936: ,p_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1937: ,p_element_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1938: ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 2034: PA_INTERFACE_UTILS_PUB.get_messages

2030: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2031: END IF;
2032:
2033: IF l_msg_count = 1 THEN
2034: PA_INTERFACE_UTILS_PUB.get_messages
2035: (p_encoded => FND_API.G_TRUE,
2036: p_msg_index => 1,
2037: p_msg_count => l_msg_count,
2038: p_msg_data => l_msg_data,

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

2094: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2095: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2096: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2097: ,p_debug_mode IN VARCHAR2 :='N'
2098: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2099: ,p_project_id IN pa_projects_all.project_id%TYPE
2100: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2101: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2102: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2187: PA_INTERFACE_UTILS_PUB.get_messages

2183: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2184: END IF;
2185:
2186: IF l_msg_count = 1 THEN
2187: PA_INTERFACE_UTILS_PUB.get_messages
2188: (p_encoded => FND_API.G_TRUE,
2189: p_msg_index => 1,
2190: p_msg_count => l_msg_count,
2191: p_msg_data => l_msg_data,

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

2227: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2228: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2229: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2230: ,p_debug_mode IN VARCHAR2 :='N'
2231: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2232: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2233: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2234: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2235: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 2329: PA_INTERFACE_UTILS_PUB.get_messages

2325: ROLLBACK TO DELETE_DLV_TASK_ASSCN_IN_BULK ;
2326: END IF ;
2327:
2328: IF l_msg_count = 1 THEN
2329: PA_INTERFACE_UTILS_PUB.get_messages
2330: (p_encoded => FND_API.G_TRUE,
2331: p_msg_index => 1,
2332: p_msg_count => l_msg_count,
2333: p_msg_data => l_msg_data,

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

2369: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2370: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2371: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2372: ,p_debug_mode IN VARCHAR2 :='N'
2373: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2374: ,p_project_id IN NUMBER
2375: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2376: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2377: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2459: PA_INTERFACE_UTILS_PUB.get_messages

2455: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2456: END IF;
2457:
2458: IF l_msg_count = 1 THEN
2459: PA_INTERFACE_UTILS_PUB.get_messages
2460: (p_encoded => FND_API.G_TRUE,
2461: p_msg_index => 1,
2462: p_msg_count => l_msg_count,
2463: p_msg_data => l_msg_data,

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

2495: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2496: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2497: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2498: ,p_debug_mode IN VARCHAR2 :='N'
2499: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2500: ,p_source_project_id IN NUMBER
2501: ,p_target_project_id IN NUMBER
2502: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
2503: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

Line 2600: PA_INTERFACE_UTILS_PUB.get_messages

2596: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2597: END IF;
2598:
2599: IF l_msg_count = 1 THEN
2600: PA_INTERFACE_UTILS_PUB.get_messages
2601: (p_encoded => FND_API.G_TRUE,
2602: p_msg_index => 1,
2603: p_msg_count => l_msg_count,
2604: p_msg_data => l_msg_data,

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

2640: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2641: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2643: ,p_debug_mode IN VARCHAR2 :='N'
2644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2645: ,p_src_task_versions_tab IN SYSTEM.pa_num_tbl_type
2646: ,p_dest_task_versions_tab IN SYSTEM.pa_num_tbl_type
2647: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2648: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2787: PA_INTERFACE_UTILS_PUB.get_messages

2783: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2784: END IF;
2785:
2786: IF l_msg_count = 1 THEN
2787: PA_INTERFACE_UTILS_PUB.get_messages
2788: (p_encoded => FND_API.G_TRUE,
2789: p_msg_index => 1,
2790: p_msg_count => l_msg_count,
2791: p_msg_data => l_msg_data,