APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_VC_1000_150

Line 532: p_ROWID IN OUT NOCOPY PA_VC_1000_150

528: /** This is called from Supplier Impact UI scrren this is a wrapper api which in turn
529: ** calls validate SI record for each single record
530: **/
531: PROCEDURE validate_insert_SI (
532: p_ROWID IN OUT NOCOPY PA_VC_1000_150
533: ,p_RECORD_STATUS IN PA_VC_1000_150
534: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
535: ,p_CI_TYPE_ID IN PA_VC_1000_150
536: ,p_CI_IMPACT_ID IN PA_VC_1000_150

Line 533: ,p_RECORD_STATUS IN PA_VC_1000_150

529: ** calls validate SI record for each single record
530: **/
531: PROCEDURE validate_insert_SI (
532: p_ROWID IN OUT NOCOPY PA_VC_1000_150
533: ,p_RECORD_STATUS IN PA_VC_1000_150
534: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
535: ,p_CI_TYPE_ID IN PA_VC_1000_150
536: ,p_CI_IMPACT_ID IN PA_VC_1000_150
537: ,P_CALLING_MODE IN VARCHAR2

Line 534: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

530: **/
531: PROCEDURE validate_insert_SI (
532: p_ROWID IN OUT NOCOPY PA_VC_1000_150
533: ,p_RECORD_STATUS IN PA_VC_1000_150
534: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
535: ,p_CI_TYPE_ID IN PA_VC_1000_150
536: ,p_CI_IMPACT_ID IN PA_VC_1000_150
537: ,P_CALLING_MODE IN VARCHAR2
538: ,P_CI_STATUS IN PA_VC_1000_150

Line 535: ,p_CI_TYPE_ID IN PA_VC_1000_150

531: PROCEDURE validate_insert_SI (
532: p_ROWID IN OUT NOCOPY PA_VC_1000_150
533: ,p_RECORD_STATUS IN PA_VC_1000_150
534: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
535: ,p_CI_TYPE_ID IN PA_VC_1000_150
536: ,p_CI_IMPACT_ID IN PA_VC_1000_150
537: ,P_CALLING_MODE IN VARCHAR2
538: ,P_CI_STATUS IN PA_VC_1000_150
539: ,P_ORG_ID IN PA_VC_1000_150

Line 536: ,p_CI_IMPACT_ID IN PA_VC_1000_150

532: p_ROWID IN OUT NOCOPY PA_VC_1000_150
533: ,p_RECORD_STATUS IN PA_VC_1000_150
534: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
535: ,p_CI_TYPE_ID IN PA_VC_1000_150
536: ,p_CI_IMPACT_ID IN PA_VC_1000_150
537: ,P_CALLING_MODE IN VARCHAR2
538: ,P_CI_STATUS IN PA_VC_1000_150
539: ,P_ORG_ID IN PA_VC_1000_150
540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 538: ,P_CI_STATUS IN PA_VC_1000_150

534: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
535: ,p_CI_TYPE_ID IN PA_VC_1000_150
536: ,p_CI_IMPACT_ID IN PA_VC_1000_150
537: ,P_CALLING_MODE IN VARCHAR2
538: ,P_CI_STATUS IN PA_VC_1000_150
539: ,P_ORG_ID IN PA_VC_1000_150
540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
541: ,p_VENDOR_NAME IN PA_VC_1000_150
542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 539: ,P_ORG_ID IN PA_VC_1000_150

535: ,p_CI_TYPE_ID IN PA_VC_1000_150
536: ,p_CI_IMPACT_ID IN PA_VC_1000_150
537: ,P_CALLING_MODE IN VARCHAR2
538: ,P_CI_STATUS IN PA_VC_1000_150
539: ,P_ORG_ID IN PA_VC_1000_150
540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
541: ,p_VENDOR_NAME IN PA_VC_1000_150
542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
543: ,p_PO_NUMBER IN PA_VC_1000_150

Line 540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

536: ,p_CI_IMPACT_ID IN PA_VC_1000_150
537: ,P_CALLING_MODE IN VARCHAR2
538: ,P_CI_STATUS IN PA_VC_1000_150
539: ,P_ORG_ID IN PA_VC_1000_150
540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
541: ,p_VENDOR_NAME IN PA_VC_1000_150
542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
543: ,p_PO_NUMBER IN PA_VC_1000_150
544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 541: ,p_VENDOR_NAME IN PA_VC_1000_150

537: ,P_CALLING_MODE IN VARCHAR2
538: ,P_CI_STATUS IN PA_VC_1000_150
539: ,P_ORG_ID IN PA_VC_1000_150
540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
541: ,p_VENDOR_NAME IN PA_VC_1000_150
542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
543: ,p_PO_NUMBER IN PA_VC_1000_150
544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

538: ,P_CI_STATUS IN PA_VC_1000_150
539: ,P_ORG_ID IN PA_VC_1000_150
540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
541: ,p_VENDOR_NAME IN PA_VC_1000_150
542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
543: ,p_PO_NUMBER IN PA_VC_1000_150
544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 543: ,p_PO_NUMBER IN PA_VC_1000_150

539: ,P_ORG_ID IN PA_VC_1000_150
540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
541: ,p_VENDOR_NAME IN PA_VC_1000_150
542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
543: ,p_PO_NUMBER IN PA_VC_1000_150
544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
547: ,p_CURRENCY_CODE IN PA_VC_1000_150

Line 544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

540: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
541: ,p_VENDOR_NAME IN PA_VC_1000_150
542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
543: ,p_PO_NUMBER IN PA_VC_1000_150
544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
547: ,p_CURRENCY_CODE IN PA_VC_1000_150
548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM

541: ,p_VENDOR_NAME IN PA_VC_1000_150
542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
543: ,p_PO_NUMBER IN PA_VC_1000_150
544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
547: ,p_CURRENCY_CODE IN PA_VC_1000_150
548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
549: ,p_CHANGE_TYPE IN PA_VC_1000_150

Line 546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

542: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
543: ,p_PO_NUMBER IN PA_VC_1000_150
544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
547: ,p_CURRENCY_CODE IN PA_VC_1000_150
548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
549: ,p_CHANGE_TYPE IN PA_VC_1000_150
550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150

Line 547: ,p_CURRENCY_CODE IN PA_VC_1000_150

543: ,p_PO_NUMBER IN PA_VC_1000_150
544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
547: ,p_CURRENCY_CODE IN PA_VC_1000_150
548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
549: ,p_CHANGE_TYPE IN PA_VC_1000_150
550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
551: ,p_Task_Id IN PA_VC_1000_150

Line 548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM

544: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
547: ,p_CURRENCY_CODE IN PA_VC_1000_150
548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
549: ,p_CHANGE_TYPE IN PA_VC_1000_150
550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
551: ,p_Task_Id IN PA_VC_1000_150
552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150

Line 549: ,p_CHANGE_TYPE IN PA_VC_1000_150

545: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
547: ,p_CURRENCY_CODE IN PA_VC_1000_150
548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
549: ,p_CHANGE_TYPE IN PA_VC_1000_150
550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
551: ,p_Task_Id IN PA_VC_1000_150
552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
553: ,p_From_Date IN PA_VC_1000_150

Line 550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150

546: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
547: ,p_CURRENCY_CODE IN PA_VC_1000_150
548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
549: ,p_CHANGE_TYPE IN PA_VC_1000_150
550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
551: ,p_Task_Id IN PA_VC_1000_150
552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
553: ,p_From_Date IN PA_VC_1000_150
554: ,p_To_Date IN PA_VC_1000_150

Line 551: ,p_Task_Id IN PA_VC_1000_150

547: ,p_CURRENCY_CODE IN PA_VC_1000_150
548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
549: ,p_CHANGE_TYPE IN PA_VC_1000_150
550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
551: ,p_Task_Id IN PA_VC_1000_150
552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
553: ,p_From_Date IN PA_VC_1000_150
554: ,p_To_Date IN PA_VC_1000_150
555: ,p_Estimated_Cost IN PA_VC_1000_150

Line 552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150

548: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
549: ,p_CHANGE_TYPE IN PA_VC_1000_150
550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
551: ,p_Task_Id IN PA_VC_1000_150
552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
553: ,p_From_Date IN PA_VC_1000_150
554: ,p_To_Date IN PA_VC_1000_150
555: ,p_Estimated_Cost IN PA_VC_1000_150
556: ,p_Quoted_Cost IN PA_VC_1000_150

Line 553: ,p_From_Date IN PA_VC_1000_150

549: ,p_CHANGE_TYPE IN PA_VC_1000_150
550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
551: ,p_Task_Id IN PA_VC_1000_150
552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
553: ,p_From_Date IN PA_VC_1000_150
554: ,p_To_Date IN PA_VC_1000_150
555: ,p_Estimated_Cost IN PA_VC_1000_150
556: ,p_Quoted_Cost IN PA_VC_1000_150
557: ,p_Negotiated_Cost IN PA_VC_1000_150

Line 554: ,p_To_Date IN PA_VC_1000_150

550: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
551: ,p_Task_Id IN PA_VC_1000_150
552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
553: ,p_From_Date IN PA_VC_1000_150
554: ,p_To_Date IN PA_VC_1000_150
555: ,p_Estimated_Cost IN PA_VC_1000_150
556: ,p_Quoted_Cost IN PA_VC_1000_150
557: ,p_Negotiated_Cost IN PA_VC_1000_150
558: ,p_Burdened_cost IN PA_VC_1000_150

Line 555: ,p_Estimated_Cost IN PA_VC_1000_150

551: ,p_Task_Id IN PA_VC_1000_150
552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
553: ,p_From_Date IN PA_VC_1000_150
554: ,p_To_Date IN PA_VC_1000_150
555: ,p_Estimated_Cost IN PA_VC_1000_150
556: ,p_Quoted_Cost IN PA_VC_1000_150
557: ,p_Negotiated_Cost IN PA_VC_1000_150
558: ,p_Burdened_cost IN PA_VC_1000_150
559: ,p_revenue_override_rate IN PA_VC_1000_150

Line 556: ,p_Quoted_Cost IN PA_VC_1000_150

552: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
553: ,p_From_Date IN PA_VC_1000_150
554: ,p_To_Date IN PA_VC_1000_150
555: ,p_Estimated_Cost IN PA_VC_1000_150
556: ,p_Quoted_Cost IN PA_VC_1000_150
557: ,p_Negotiated_Cost IN PA_VC_1000_150
558: ,p_Burdened_cost IN PA_VC_1000_150
559: ,p_revenue_override_rate IN PA_VC_1000_150
560: ,p_audit_history_number in number

Line 557: ,p_Negotiated_Cost IN PA_VC_1000_150

553: ,p_From_Date IN PA_VC_1000_150
554: ,p_To_Date IN PA_VC_1000_150
555: ,p_Estimated_Cost IN PA_VC_1000_150
556: ,p_Quoted_Cost IN PA_VC_1000_150
557: ,p_Negotiated_Cost IN PA_VC_1000_150
558: ,p_Burdened_cost IN PA_VC_1000_150
559: ,p_revenue_override_rate IN PA_VC_1000_150
560: ,p_audit_history_number in number
561: ,p_current_audit_flag in varchar2

Line 558: ,p_Burdened_cost IN PA_VC_1000_150

554: ,p_To_Date IN PA_VC_1000_150
555: ,p_Estimated_Cost IN PA_VC_1000_150
556: ,p_Quoted_Cost IN PA_VC_1000_150
557: ,p_Negotiated_Cost IN PA_VC_1000_150
558: ,p_Burdened_cost IN PA_VC_1000_150
559: ,p_revenue_override_rate IN PA_VC_1000_150
560: ,p_audit_history_number in number
561: ,p_current_audit_flag in varchar2
562: ,p_Original_supp_trans_id in number

Line 559: ,p_revenue_override_rate IN PA_VC_1000_150

555: ,p_Estimated_Cost IN PA_VC_1000_150
556: ,p_Quoted_Cost IN PA_VC_1000_150
557: ,p_Negotiated_Cost IN PA_VC_1000_150
558: ,p_Burdened_cost IN PA_VC_1000_150
559: ,p_revenue_override_rate IN PA_VC_1000_150
560: ,p_audit_history_number in number
561: ,p_current_audit_flag in varchar2
562: ,p_Original_supp_trans_id in number
563: ,p_Source_supp_trans_id in number

Line 573: ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150

569: ,p_change_reason_code in varchar2
570: ,p_quote_negotiation_reference in varchar2
571: ,p_need_by_date in varchar2
572: -- gboomina modified for supplier cost 12.1.3 requirement - end
573: ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150
574: ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150
575: ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150
576: ,x_return_status IN OUT NOCOPY VARCHAR2
577: ,x_msg_data IN OUT NOCOPY VARCHAR2

Line 574: ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150

570: ,p_quote_negotiation_reference in varchar2
571: ,p_need_by_date in varchar2
572: -- gboomina modified for supplier cost 12.1.3 requirement - end
573: ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150
574: ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150
575: ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150
576: ,x_return_status IN OUT NOCOPY VARCHAR2
577: ,x_msg_data IN OUT NOCOPY VARCHAR2
578: ,x_msg_count IN OUT NOCOPY NUMBER

Line 575: ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150

571: ,p_need_by_date in varchar2
572: -- gboomina modified for supplier cost 12.1.3 requirement - end
573: ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150
574: ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150
575: ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150
576: ,x_return_status IN OUT NOCOPY VARCHAR2
577: ,x_msg_data IN OUT NOCOPY VARCHAR2
578: ,x_msg_count IN OUT NOCOPY NUMBER
579: ) IS