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_EVENT_PUB dependencies on PA_PROJECTS_ALL

Line 46: P_Organization_Id pa_projects_all.org_id%type;

42: rowid varchar2(18);
43: l_event_type_classification pa_event_types.event_type_classification%type;
44: P_project_id pa_events.project_id%type;
45: P_task_id pa_events.task_id%type;
46: P_Organization_Id pa_projects_all.org_id%type;
47: p_inv_org_id pa_events.inventory_item_id%type;
48: p_agreement_id pa_events.agreement_id%type; -- Federal Uptake
49:
50: p_event_in_rec Event_Rec_In_Type;

Line 59: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;

55: p_return_msg VARCHAR2(2000);
56: p_validate_status VARCHAR2(1):='Y';
57:
58: /* Declaring varible for MCB2 */
59: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
60: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
61: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

Line 60: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

56: p_validate_status VARCHAR2(1):='Y';
57:
58: /* Declaring varible for MCB2 */
59: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
60: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
61: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

Line 61: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

57:
58: /* Declaring varible for MCB2 */
59: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
60: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
61: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

Line 66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

74: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
82: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

75: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
82: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
83: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

76: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
82: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
83: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
84:

Line 81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

77: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
82: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
83: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
84:
85: l_event_number pa_events.event_num%type;

Line 82: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

78: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
82: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
83: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
84:
85: l_event_number pa_events.event_num%type;
86: l_encoded varchar2(1):='F';

Line 83: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

79: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
80: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
82: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
83: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
84:
85: l_event_number pa_events.event_num%type;
86: l_encoded varchar2(1):='F';
87: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;

Line 1102: From pa_projects_all

1098:
1099: Cursor chk_proj_curs(P_project_number VARCHAR2)
1100: Is
1101: Select project_id
1102: From pa_projects_all
1103: Where segment1 = P_project_number;
1104:
1105: p_inv_org_id pa_events.inventory_item_id%type;
1106: P_project_id pa_events.project_id%type;

Line 1107: l_project_id pa_projects_all.project_id%type;

1103: Where segment1 = P_project_number;
1104:
1105: p_inv_org_id pa_events.inventory_item_id%type;
1106: P_project_id pa_events.project_id%type;
1107: l_project_id pa_projects_all.project_id%type;
1108: P_task_id pa_events.task_id%type;
1109: l_task_id pa_events.task_id%type;
1110: P_Organization_Id pa_projects_all.org_id%type;
1111: l_event_type_classification pa_event_types.event_type_classification%type;

Line 1110: P_Organization_Id pa_projects_all.org_id%type;

1106: P_project_id pa_events.project_id%type;
1107: l_project_id pa_projects_all.project_id%type;
1108: P_task_id pa_events.task_id%type;
1109: l_task_id pa_events.task_id%type;
1110: P_Organization_Id pa_projects_all.org_id%type;
1111: l_event_type_classification pa_event_types.event_type_classification%type;
1112: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake
1113:
1114: P_event_id_out pa_events.event_id%type;

Line 1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;

1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1149: l_project_bil_rate_type pa_events.project_rate_type%type;
1150: l_project_bil_rate_date pa_events.project_rate_date%type;

Line 1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;

1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1149: l_project_bil_rate_type pa_events.project_rate_type%type;
1150: l_project_bil_rate_date pa_events.project_rate_date%type;
1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;

Line 1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;

1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1149: l_project_bil_rate_type pa_events.project_rate_type%type;
1150: l_project_bil_rate_date pa_events.project_rate_date%type;
1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;

Line 1166: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1163: l_inventory_org_id pa_events.inventory_org_id%type;
1164: l_inventory_item_id pa_events.inventory_item_id%type;
1165: l_organization_id pa_events.organization_id%type;
1166: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1167: l_encoded varchar2(1):='F';
1168: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;
1169: l_record_version_number pa_events.record_version_number%TYPE;
1170:

Line 1465: From pa_projects_all

1461: Into l_multi_currency_billing_flag
1462: ,l_funding_rate_date_code
1463: ,l_project_bil_rate_date_code
1464: ,l_projfunc_bil_rate_date_code
1465: From pa_projects_all
1466: Where project_id=P_project_id;
1467:
1468:
1469: --Log Message