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_CI_SUPPLIER_UTILS dependencies on PA_VC_1000_150

Line 4: --TYPE PA_VC_1000_150 IS VARRAY(1000) OF VARCHAR2(150);

1: package PA_CI_SUPPLIER_UTILS AUTHID CURRENT_USER AS
2: --$Header: PASIUTLS.pls 120.0.12010000.9 2010/04/26 15:18:26 gboomina ship $
3:
4: --TYPE PA_VC_1000_150 IS VARRAY(1000) OF VARCHAR2(150);
5: --TYPE PA_VC_1000_NUM IS VARRAY(1000) OF NUMBER;
6:
7: PROCEDURE print_msg(p_msg varchar2);
8:

Line 55: p_ROWID IN OUT NOCOPY PA_VC_1000_150

51: ,x_error_msg_code OUT NOCOPY VARCHAR2
52: );
53:
54: PROCEDURE validate_insert_SI(
55: p_ROWID IN OUT NOCOPY PA_VC_1000_150
56: ,p_RECORD_STATUS IN PA_VC_1000_150
57: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
58: ,p_CI_TYPE_ID IN PA_VC_1000_150
59: ,p_CI_IMPACT_ID IN PA_VC_1000_150

Line 56: ,p_RECORD_STATUS IN PA_VC_1000_150

52: );
53:
54: PROCEDURE validate_insert_SI(
55: p_ROWID IN OUT NOCOPY PA_VC_1000_150
56: ,p_RECORD_STATUS IN PA_VC_1000_150
57: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
58: ,p_CI_TYPE_ID IN PA_VC_1000_150
59: ,p_CI_IMPACT_ID IN PA_VC_1000_150
60: ,P_CALLING_MODE IN VARCHAR2

Line 57: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

53:
54: PROCEDURE validate_insert_SI(
55: p_ROWID IN OUT NOCOPY PA_VC_1000_150
56: ,p_RECORD_STATUS IN PA_VC_1000_150
57: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
58: ,p_CI_TYPE_ID IN PA_VC_1000_150
59: ,p_CI_IMPACT_ID IN PA_VC_1000_150
60: ,P_CALLING_MODE IN VARCHAR2
61: ,P_CI_STATUS IN PA_VC_1000_150

Line 58: ,p_CI_TYPE_ID IN PA_VC_1000_150

54: PROCEDURE validate_insert_SI(
55: p_ROWID IN OUT NOCOPY PA_VC_1000_150
56: ,p_RECORD_STATUS IN PA_VC_1000_150
57: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
58: ,p_CI_TYPE_ID IN PA_VC_1000_150
59: ,p_CI_IMPACT_ID IN PA_VC_1000_150
60: ,P_CALLING_MODE IN VARCHAR2
61: ,P_CI_STATUS IN PA_VC_1000_150
62: ,P_ORG_ID IN PA_VC_1000_150

Line 59: ,p_CI_IMPACT_ID IN PA_VC_1000_150

55: p_ROWID IN OUT NOCOPY PA_VC_1000_150
56: ,p_RECORD_STATUS IN PA_VC_1000_150
57: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
58: ,p_CI_TYPE_ID IN PA_VC_1000_150
59: ,p_CI_IMPACT_ID IN PA_VC_1000_150
60: ,P_CALLING_MODE IN VARCHAR2
61: ,P_CI_STATUS IN PA_VC_1000_150
62: ,P_ORG_ID IN PA_VC_1000_150
63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 61: ,P_CI_STATUS IN PA_VC_1000_150

57: ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
58: ,p_CI_TYPE_ID IN PA_VC_1000_150
59: ,p_CI_IMPACT_ID IN PA_VC_1000_150
60: ,P_CALLING_MODE IN VARCHAR2
61: ,P_CI_STATUS IN PA_VC_1000_150
62: ,P_ORG_ID IN PA_VC_1000_150
63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
64: ,p_VENDOR_NAME IN PA_VC_1000_150
65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 62: ,P_ORG_ID IN PA_VC_1000_150

58: ,p_CI_TYPE_ID IN PA_VC_1000_150
59: ,p_CI_IMPACT_ID IN PA_VC_1000_150
60: ,P_CALLING_MODE IN VARCHAR2
61: ,P_CI_STATUS IN PA_VC_1000_150
62: ,P_ORG_ID IN PA_VC_1000_150
63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
64: ,p_VENDOR_NAME IN PA_VC_1000_150
65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
66: ,p_PO_NUMBER IN PA_VC_1000_150

Line 63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

59: ,p_CI_IMPACT_ID IN PA_VC_1000_150
60: ,P_CALLING_MODE IN VARCHAR2
61: ,P_CI_STATUS IN PA_VC_1000_150
62: ,P_ORG_ID IN PA_VC_1000_150
63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
64: ,p_VENDOR_NAME IN PA_VC_1000_150
65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
66: ,p_PO_NUMBER IN PA_VC_1000_150
67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 64: ,p_VENDOR_NAME IN PA_VC_1000_150

60: ,P_CALLING_MODE IN VARCHAR2
61: ,P_CI_STATUS IN PA_VC_1000_150
62: ,P_ORG_ID IN PA_VC_1000_150
63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
64: ,p_VENDOR_NAME IN PA_VC_1000_150
65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
66: ,p_PO_NUMBER IN PA_VC_1000_150
67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

61: ,P_CI_STATUS IN PA_VC_1000_150
62: ,P_ORG_ID IN PA_VC_1000_150
63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
64: ,p_VENDOR_NAME IN PA_VC_1000_150
65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
66: ,p_PO_NUMBER IN PA_VC_1000_150
67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 66: ,p_PO_NUMBER IN PA_VC_1000_150

62: ,P_ORG_ID IN PA_VC_1000_150
63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
64: ,p_VENDOR_NAME IN PA_VC_1000_150
65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
66: ,p_PO_NUMBER IN PA_VC_1000_150
67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
70: ,p_CURRENCY_CODE IN PA_VC_1000_150

Line 67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

63: ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
64: ,p_VENDOR_NAME IN PA_VC_1000_150
65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
66: ,p_PO_NUMBER IN PA_VC_1000_150
67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
70: ,p_CURRENCY_CODE IN PA_VC_1000_150
71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM

Line 68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM

64: ,p_VENDOR_NAME IN PA_VC_1000_150
65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
66: ,p_PO_NUMBER IN PA_VC_1000_150
67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
70: ,p_CURRENCY_CODE IN PA_VC_1000_150
71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
72: ,p_CHANGE_TYPE IN PA_VC_1000_150

Line 69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM

65: ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
66: ,p_PO_NUMBER IN PA_VC_1000_150
67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
70: ,p_CURRENCY_CODE IN PA_VC_1000_150
71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
72: ,p_CHANGE_TYPE IN PA_VC_1000_150
73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150

Line 70: ,p_CURRENCY_CODE IN PA_VC_1000_150

66: ,p_PO_NUMBER IN PA_VC_1000_150
67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
70: ,p_CURRENCY_CODE IN PA_VC_1000_150
71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
72: ,p_CHANGE_TYPE IN PA_VC_1000_150
73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
74: ,p_Task_Id IN PA_VC_1000_150

Line 71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM

67: ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
70: ,p_CURRENCY_CODE IN PA_VC_1000_150
71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
72: ,p_CHANGE_TYPE IN PA_VC_1000_150
73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
74: ,p_Task_Id IN PA_VC_1000_150
75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150

Line 72: ,p_CHANGE_TYPE IN PA_VC_1000_150

68: ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
70: ,p_CURRENCY_CODE IN PA_VC_1000_150
71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
72: ,p_CHANGE_TYPE IN PA_VC_1000_150
73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
74: ,p_Task_Id IN PA_VC_1000_150
75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
76: ,p_From_Date IN PA_VC_1000_150

Line 73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150

69: ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
70: ,p_CURRENCY_CODE IN PA_VC_1000_150
71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
72: ,p_CHANGE_TYPE IN PA_VC_1000_150
73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
74: ,p_Task_Id IN PA_VC_1000_150
75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
76: ,p_From_Date IN PA_VC_1000_150
77: ,p_To_Date IN PA_VC_1000_150

Line 74: ,p_Task_Id IN PA_VC_1000_150

70: ,p_CURRENCY_CODE IN PA_VC_1000_150
71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
72: ,p_CHANGE_TYPE IN PA_VC_1000_150
73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
74: ,p_Task_Id IN PA_VC_1000_150
75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
76: ,p_From_Date IN PA_VC_1000_150
77: ,p_To_Date IN PA_VC_1000_150
78: ,p_Estimated_Cost IN PA_VC_1000_150

Line 75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150

71: ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
72: ,p_CHANGE_TYPE IN PA_VC_1000_150
73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
74: ,p_Task_Id IN PA_VC_1000_150
75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
76: ,p_From_Date IN PA_VC_1000_150
77: ,p_To_Date IN PA_VC_1000_150
78: ,p_Estimated_Cost IN PA_VC_1000_150
79: ,p_Quoted_Cost IN PA_VC_1000_150

Line 76: ,p_From_Date IN PA_VC_1000_150

72: ,p_CHANGE_TYPE IN PA_VC_1000_150
73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
74: ,p_Task_Id IN PA_VC_1000_150
75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
76: ,p_From_Date IN PA_VC_1000_150
77: ,p_To_Date IN PA_VC_1000_150
78: ,p_Estimated_Cost IN PA_VC_1000_150
79: ,p_Quoted_Cost IN PA_VC_1000_150
80: ,p_Negotiated_Cost IN PA_VC_1000_150

Line 77: ,p_To_Date IN PA_VC_1000_150

73: ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
74: ,p_Task_Id IN PA_VC_1000_150
75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
76: ,p_From_Date IN PA_VC_1000_150
77: ,p_To_Date IN PA_VC_1000_150
78: ,p_Estimated_Cost IN PA_VC_1000_150
79: ,p_Quoted_Cost IN PA_VC_1000_150
80: ,p_Negotiated_Cost IN PA_VC_1000_150
81: ,p_Burdened_cost IN PA_VC_1000_150

Line 78: ,p_Estimated_Cost IN PA_VC_1000_150

74: ,p_Task_Id IN PA_VC_1000_150
75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
76: ,p_From_Date IN PA_VC_1000_150
77: ,p_To_Date IN PA_VC_1000_150
78: ,p_Estimated_Cost IN PA_VC_1000_150
79: ,p_Quoted_Cost IN PA_VC_1000_150
80: ,p_Negotiated_Cost IN PA_VC_1000_150
81: ,p_Burdened_cost IN PA_VC_1000_150
82: ,p_revenue_override_rate IN PA_VC_1000_150

Line 79: ,p_Quoted_Cost IN PA_VC_1000_150

75: ,p_Resource_List_Mem_Id IN PA_VC_1000_150
76: ,p_From_Date IN PA_VC_1000_150
77: ,p_To_Date IN PA_VC_1000_150
78: ,p_Estimated_Cost IN PA_VC_1000_150
79: ,p_Quoted_Cost IN PA_VC_1000_150
80: ,p_Negotiated_Cost IN PA_VC_1000_150
81: ,p_Burdened_cost IN PA_VC_1000_150
82: ,p_revenue_override_rate IN PA_VC_1000_150
83: ,p_audit_history_number in number default null

Line 80: ,p_Negotiated_Cost IN PA_VC_1000_150

76: ,p_From_Date IN PA_VC_1000_150
77: ,p_To_Date IN PA_VC_1000_150
78: ,p_Estimated_Cost IN PA_VC_1000_150
79: ,p_Quoted_Cost IN PA_VC_1000_150
80: ,p_Negotiated_Cost IN PA_VC_1000_150
81: ,p_Burdened_cost IN PA_VC_1000_150
82: ,p_revenue_override_rate IN PA_VC_1000_150
83: ,p_audit_history_number in number default null
84: ,p_current_audit_flag in varchar2 default 'Y'

Line 81: ,p_Burdened_cost IN PA_VC_1000_150

77: ,p_To_Date IN PA_VC_1000_150
78: ,p_Estimated_Cost IN PA_VC_1000_150
79: ,p_Quoted_Cost IN PA_VC_1000_150
80: ,p_Negotiated_Cost IN PA_VC_1000_150
81: ,p_Burdened_cost IN PA_VC_1000_150
82: ,p_revenue_override_rate IN PA_VC_1000_150
83: ,p_audit_history_number in number default null
84: ,p_current_audit_flag in varchar2 default 'Y'
85: ,p_Original_supp_trans_id in number default null

Line 82: ,p_revenue_override_rate IN PA_VC_1000_150

78: ,p_Estimated_Cost IN PA_VC_1000_150
79: ,p_Quoted_Cost IN PA_VC_1000_150
80: ,p_Negotiated_Cost IN PA_VC_1000_150
81: ,p_Burdened_cost IN PA_VC_1000_150
82: ,p_revenue_override_rate IN PA_VC_1000_150
83: ,p_audit_history_number in number default null
84: ,p_current_audit_flag in varchar2 default 'Y'
85: ,p_Original_supp_trans_id in number default null
86: ,p_Source_supp_trans_id in number default null

Line 96: ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150

92: ,p_change_reason_code in varchar2
93: ,p_quote_negotiation_reference in varchar2
94: ,p_need_by_date in varchar2
95: -- gboomina modified for supplier cost 12.1.3 requirement - end
96: ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150
97: ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150
98: ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150
99: ,x_return_status IN OUT NOCOPY VARCHAR2
100: ,x_msg_data IN OUT NOCOPY VARCHAR2

Line 97: ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150

93: ,p_quote_negotiation_reference in varchar2
94: ,p_need_by_date in varchar2
95: -- gboomina modified for supplier cost 12.1.3 requirement - end
96: ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150
97: ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150
98: ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150
99: ,x_return_status IN OUT NOCOPY VARCHAR2
100: ,x_msg_data IN OUT NOCOPY VARCHAR2
101: ,x_msg_count IN OUT NOCOPY NUMBER

Line 98: ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150

94: ,p_need_by_date in varchar2
95: -- gboomina modified for supplier cost 12.1.3 requirement - end
96: ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150
97: ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150
98: ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150
99: ,x_return_status IN OUT NOCOPY VARCHAR2
100: ,x_msg_data IN OUT NOCOPY VARCHAR2
101: ,x_msg_count IN OUT NOCOPY NUMBER
102: );