APPS.CS_CONTRACT_BILLING dependencies on CS_CP_SERVICES

Line 151: CS_CP_SERVICES SRV,

147: SRV.BILL_ON BILL_ON,
148: SRV.SERVICE_INVENTORY_ITEM_ID INVENTORY_ITEM_ID
149: FROM
150: CS_CONTRACTS CON,
151: CS_CP_SERVICES SRV,
152: CS_CONTRACT_STATUSES STS
153: WHERE
154: CON.CONTRACT_ID = SRV.CONTRACT_ID AND
155: CON.CONTRACT_NUMBER =

Line 188: CS_CP_SERVICES SRV,

184: SRV.SERVICE_INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
185: PROD.QUANTITY QUANTITY
186: FROM
187: CS_CONTRACTS CON,
188: CS_CP_SERVICES SRV,
189: CS_CUSTOMER_PRODUCTS PROD,
190: CS_CONTRACT_COVERAGE_LEVELS COVL,
191: CS_COVERED_PRODUCTS COVP,
192: CS_CONTRACT_STATUSES STS

Line 496: /* update CS_CP_SERVICES set the transaction_availability_code*/

492: NULL);
493:
494: IF v_retcode = SUCCESS THEN
495:
496: /* update CS_CP_SERVICES set the transaction_availability_code*/
497: /* To 'RESERVED' and update the column Next_bill_date with the*/
498: /* new Next_Bill_date */
499:
500:

Line 501: v_retcode := UPDATE_CS_CP_SERVICES

497: /* To 'RESERVED' and update the column Next_bill_date with the*/
498: /* new Next_Bill_date */
499:
500:
501: v_retcode := UPDATE_CS_CP_SERVICES
502: (
503: p_contract_id,
504: p_cp_service_id,
505: p_Next_Bill_date

Line 968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Err in UPdate CS_CP_SERVICES :'

964: Current_error_Code := to_Char(SQLCODE);
965: FND_FILE.PUT_LINE( FND_FILE.LOG,
966: 'Error in Insert_CS_cont_bill_iface ' );
967: v_msg_data := FND_MESSAGE.Get;
968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Err in UPdate CS_CP_SERVICES :'
969: || v_msg_data);
970: FND_FILE.PUT_LINE( FND_FILE.LOG, SQLCODE );
971: return (v_retcode);
972:

Line 976: FUNCTION Update_CS_CP_Services

972:
973: END;
974:
975:
976: FUNCTION Update_CS_CP_Services
977: (
978: P_CONTRACT_ID IN NUMBER,
979: P_CP_SERVICE_ID IN NUMBER,
980: P_Next_Bill_Date IN DATE

Line 986: FND_FILE.PUT_LINE( FND_FILE.LOG, 'CS_CP_SERVICES Before' );

982:
983: v_retcode NUMBER := SUCCESS;
984: dummy VARCHAR2(02) ;
985: BEGIN
986: FND_FILE.PUT_LINE( FND_FILE.LOG, 'CS_CP_SERVICES Before' );
987:
988:
989: -- This select is required only to lock the record.
990: SELECT 'X'

Line 992: FROM CS_CP_SERVICES

988:
989: -- This select is required only to lock the record.
990: SELECT 'X'
991: INTO dummy
992: FROM CS_CP_SERVICES
993: WHERE contract_id = p_contract_id AND
994: cp_service_id = p_cp_service_id
995: FOR UPDATE OF cp_service_id;
996:

Line 998: UPDATE CS_CP_SERVICES

994: cp_service_id = p_cp_service_id
995: FOR UPDATE OF cp_service_id;
996:
997:
998: UPDATE CS_CP_SERVICES
999: -- SET SERVICE_TXN_AVAILABILITY_CODE = 'RESERVED' ,
1000: SET NEXT_BILL_DATE = p_Next_Bill_Date
1001: WHERE CONTRACT_ID = p_Contract_Id AND
1002: CP_SERVICE_ID = p_cp_service_id;

Line 1005: FND_FILE.PUT_LINE( FND_FILE.LOG, 'CS_CP_SERVICES Updated' );

1001: WHERE CONTRACT_ID = p_Contract_Id AND
1002: CP_SERVICE_ID = p_cp_service_id;
1003:
1004: Current_Error_Code := to_char(SQLCODE);
1005: FND_FILE.PUT_LINE( FND_FILE.LOG, 'CS_CP_SERVICES Updated' );
1006: return (v_retcode);
1007:
1008: EXCEPTION
1009: WHEN others THEN