DBA Data[Home] [Help]

APPS.CS_SERVICETRAN_PVT dependencies on CS_CP_SERVICE_TRANSACTIONS_S

Line 5: SELECT CS_CP_SERVICE_TRANSACTIONS_S.nextval FROM SYS.DUAL;

1: PACKAGE BODY CS_SERVICETRAN_PVT AS
2: /* $Header: csctstrb.pls 115.1 99/07/16 08:54:31 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CP_SERVICE_TRANSACTIONS_S.nextval FROM SYS.DUAL;
6: l_seq_id NUMBER := 0;
7: BEGIN
8: OPEN get_seq_id_csr;
9: FETCH get_seq_id_csr INTO l_seq_id;

Line 558: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := NULL,

554: p_accounting_rule_id IN NUMBER := NULL,
555: p_payment_terms_id IN NUMBER := NULL,
556: p_service_order_line_id IN NUMBER := NULL,
557: p_service_order_number IN NUMBER := NULL,
558: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := NULL,
559: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := NULL,
560: p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := NULL,
561: p_coverage_schedule_id IN NUMBER := NULL,
562: p_duration_quantity IN NUMBER := NULL,

Line 559: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := NULL,

555: p_payment_terms_id IN NUMBER := NULL,
556: p_service_order_line_id IN NUMBER := NULL,
557: p_service_order_number IN NUMBER := NULL,
558: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := NULL,
559: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := NULL,
560: p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := NULL,
561: p_coverage_schedule_id IN NUMBER := NULL,
562: p_duration_quantity IN NUMBER := NULL,
563: p_unit_of_measure_code IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := NULL,

Line 1719: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1715: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1716: p_payment_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1717: p_service_order_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1718: p_service_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1719: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1720: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1721: p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1722: p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1723: p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1720: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1716: p_payment_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1717: p_service_order_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1718: p_service_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1719: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1720: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1721: p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1722: p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1723: p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1724: p_unit_of_measure_code IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 2087: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

2083: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2084: p_payment_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2085: p_service_order_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2086: p_service_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2087: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2088: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2089: p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2090: p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2091: p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 2088: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2084: p_payment_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2085: p_service_order_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2086: p_service_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2087: p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2088: p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2089: p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2090: p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2091: p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2092: p_unit_of_measure_code IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,