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.CS_GET_CONTRACTS_PUB dependencies on CS_CONTRACTS

Line 17: V_Contract_Id CS_CONTRACTS.CONTRACT_ID%TYPE,

13: -- DATA STRUCTURES
14: *****************************************************************************/
15:
16: TYPE Contracts_Rec_Type IS RECORD (
17: V_Contract_Id CS_CONTRACTS.CONTRACT_ID%TYPE,
18: V_Contract_Number CS_CONTRACTS.CONTRACT_NUMBER%TYPE,
19: V_Contract_Status CS_CONTRACT_STATUSES.NAME%TYPE,
20: V_Contract_Start_Date CS_CONTRACTS.START_DATE_ACTIVE%TYPE,
21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,

Line 18: V_Contract_Number CS_CONTRACTS.CONTRACT_NUMBER%TYPE,

14: *****************************************************************************/
15:
16: TYPE Contracts_Rec_Type IS RECORD (
17: V_Contract_Id CS_CONTRACTS.CONTRACT_ID%TYPE,
18: V_Contract_Number CS_CONTRACTS.CONTRACT_NUMBER%TYPE,
19: V_Contract_Status CS_CONTRACT_STATUSES.NAME%TYPE,
20: V_Contract_Start_Date CS_CONTRACTS.START_DATE_ACTIVE%TYPE,
21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,
22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,

Line 20: V_Contract_Start_Date CS_CONTRACTS.START_DATE_ACTIVE%TYPE,

16: TYPE Contracts_Rec_Type IS RECORD (
17: V_Contract_Id CS_CONTRACTS.CONTRACT_ID%TYPE,
18: V_Contract_Number CS_CONTRACTS.CONTRACT_NUMBER%TYPE,
19: V_Contract_Status CS_CONTRACT_STATUSES.NAME%TYPE,
20: V_Contract_Start_Date CS_CONTRACTS.START_DATE_ACTIVE%TYPE,
21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,
22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,
23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,
24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,

Line 21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,

17: V_Contract_Id CS_CONTRACTS.CONTRACT_ID%TYPE,
18: V_Contract_Number CS_CONTRACTS.CONTRACT_NUMBER%TYPE,
19: V_Contract_Status CS_CONTRACT_STATUSES.NAME%TYPE,
20: V_Contract_Start_Date CS_CONTRACTS.START_DATE_ACTIVE%TYPE,
21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,
22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,
23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,
24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,
25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,

Line 22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,

18: V_Contract_Number CS_CONTRACTS.CONTRACT_NUMBER%TYPE,
19: V_Contract_Status CS_CONTRACT_STATUSES.NAME%TYPE,
20: V_Contract_Start_Date CS_CONTRACTS.START_DATE_ACTIVE%TYPE,
21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,
22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,
23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,
24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,
25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,
26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,

Line 23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,

19: V_Contract_Status CS_CONTRACT_STATUSES.NAME%TYPE,
20: V_Contract_Start_Date CS_CONTRACTS.START_DATE_ACTIVE%TYPE,
21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,
22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,
23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,
24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,
25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,
26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,
27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,

Line 24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,

20: V_Contract_Start_Date CS_CONTRACTS.START_DATE_ACTIVE%TYPE,
21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,
22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,
23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,
24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,
25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,
26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,
27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,
28: V_Renewal_Rule CS_CONTRACTS.RENEWAL_RULE%TYPE,

Line 25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,

21: V_Contract_End_Date CS_CONTRACTS.END_DATE_ACTIVE%TYPE,
22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,
23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,
24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,
25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,
26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,
27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,
28: V_Renewal_Rule CS_CONTRACTS.RENEWAL_RULE%TYPE,
29: V_Termination_Rule CS_CONTRACTS.TERMINATION_RULE%TYPE,

Line 26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,

22: V_Contract_Duration CS_CONTRACTS.DURATION%TYPE,
23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,
24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,
25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,
26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,
27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,
28: V_Renewal_Rule CS_CONTRACTS.RENEWAL_RULE%TYPE,
29: V_Termination_Rule CS_CONTRACTS.TERMINATION_RULE%TYPE,
30: V_Contract_Amount CS_CONTRACTS.CONTRACT_AMOUNT%TYPE,

Line 27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,

23: V_Currency_Code CS_CONTRACTS.CURRENCY_CODE%TYPE,
24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,
25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,
26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,
27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,
28: V_Renewal_Rule CS_CONTRACTS.RENEWAL_RULE%TYPE,
29: V_Termination_Rule CS_CONTRACTS.TERMINATION_RULE%TYPE,
30: V_Contract_Amount CS_CONTRACTS.CONTRACT_AMOUNT%TYPE,
31: V_Service_Id CS_CP_SERVICES.CP_SERVICE_ID%TYPE,

Line 28: V_Renewal_Rule CS_CONTRACTS.RENEWAL_RULE%TYPE,

24: V_Bill_On CS_CONTRACTS.BILL_ON%TYPE,
25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,
26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,
27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,
28: V_Renewal_Rule CS_CONTRACTS.RENEWAL_RULE%TYPE,
29: V_Termination_Rule CS_CONTRACTS.TERMINATION_RULE%TYPE,
30: V_Contract_Amount CS_CONTRACTS.CONTRACT_AMOUNT%TYPE,
31: V_Service_Id CS_CP_SERVICES.CP_SERVICE_ID%TYPE,
32: V_Service

Line 29: V_Termination_Rule CS_CONTRACTS.TERMINATION_RULE%TYPE,

25: V_First_Bill_Date CS_CONTRACTS.FIRST_BILL_DATE%TYPE,
26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,
27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,
28: V_Renewal_Rule CS_CONTRACTS.RENEWAL_RULE%TYPE,
29: V_Termination_Rule CS_CONTRACTS.TERMINATION_RULE%TYPE,
30: V_Contract_Amount CS_CONTRACTS.CONTRACT_AMOUNT%TYPE,
31: V_Service_Id CS_CP_SERVICES.CP_SERVICE_ID%TYPE,
32: V_Service
33: MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,

Line 30: V_Contract_Amount CS_CONTRACTS.CONTRACT_AMOUNT%TYPE,

26: V_Next_Bill_Date CS_CONTRACTS.NEXT_BILL_DATE%TYPE,
27: V_Workflow_Process_Id CS_CONTRACTS.WORKFLOW_PROCESS_ID%TYPE,
28: V_Renewal_Rule CS_CONTRACTS.RENEWAL_RULE%TYPE,
29: V_Termination_Rule CS_CONTRACTS.TERMINATION_RULE%TYPE,
30: V_Contract_Amount CS_CONTRACTS.CONTRACT_AMOUNT%TYPE,
31: V_Service_Id CS_CP_SERVICES.CP_SERVICE_ID%TYPE,
32: V_Service
33: MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,
34: V_Service_Start_Date CS_CP_SERVICES_ALL.START_DATE_ACTIVE%TYPE,