APPS.GMD_QC_TESTS_PUB dependencies on GMD_CUSTOMER_TESTS

Line 85: l_qc_cust_tests_rec GMD_CUSTOMER_TESTS%ROWTYPE;

81: l_msg_data VARCHAR2(2000);
82: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
83: l_qc_tests_rec GMD_QC_TESTS%ROWTYPE;
84: l_qc_tests_rec_in GMD_QC_TESTS%ROWTYPE;
85: l_qc_cust_tests_rec GMD_CUSTOMER_TESTS%ROWTYPE;
86: l_qc_test_values_rec_in GMD_QC_TEST_VALUES%ROWTYPE;
87: l_qc_test_values_rec GMD_QC_TEST_VALUES%ROWTYPE;
88: l_qc_test_values_tbl GMD_QC_TESTS_PUB.qc_test_values_tbl;
89: l_qc_cust_tests_tbl GMD_QC_TESTS_PUB.qc_cust_tests_tbl;

Line 381: GMD_CUSTOMER_TESTS_GRP.VALIDATE_BEFORE_INSERT(

377: END IF;
378:
379: -- Validate Values definition
380:
381: GMD_CUSTOMER_TESTS_GRP.VALIDATE_BEFORE_INSERT(
382: p_init_msg_list => p_init_msg_list,
383: p_customer_tests_rec => l_qc_cust_tests_rec,
384: x_return_status => l_return_status,
385: x_message_data => l_msg_data);

Line 397: IF NOT GMD_CUSTOMER_TESTS_PVT.INSERT_ROW(

393: -- Set the Who column definitions
394: l_qc_cust_tests_rec.created_by := l_user_id;
395: l_qc_cust_tests_rec.last_updated_by := l_user_id;
396:
397: IF NOT GMD_CUSTOMER_TESTS_PVT.INSERT_ROW(
398: p_customer_tests_rec => l_qc_cust_tests_rec ) THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:

Line 863: l_qc_cust_tests_rec GMD_CUSTOMER_TESTS%ROWTYPE;

859: l_msg_data VARCHAR2(2000);
860: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
861: l_qc_tests_rec GMD_QC_TESTS%ROWTYPE;
862: l_qc_tests_rec_in GMD_QC_TESTS%ROWTYPE;
863: l_qc_cust_tests_rec GMD_CUSTOMER_TESTS%ROWTYPE;
864: l_deleted_rows NUMBER;
865: l_test_id NUMBER(10);
866:
867: BEGIN

Line 949: GMD_CUSTOMER_TESTS_GRP.VALIDATE_BEFORE_DELETE(

945: END IF;
946:
947: -- Call Validate Routine to validate Header
948:
949: GMD_CUSTOMER_TESTS_GRP.VALIDATE_BEFORE_DELETE(
950: p_init_msg_list => p_init_msg_list,
951: p_test_id => l_qc_cust_tests_rec.test_id,
952: p_cust_id => l_qc_cust_tests_rec.cust_id,
953: x_return_status => l_return_status,

Line 963: IF NOT GMD_CUSTOMER_TESTS_PVT.LOCK_ROW(

959:
960:
961: -- LOCK THE ROW
962:
963: IF NOT GMD_CUSTOMER_TESTS_PVT.LOCK_ROW(
964: p_test_id => l_qc_cust_tests_rec.test_id,
965: p_cust_id => l_qc_cust_tests_rec.cust_id) THEN
966: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
967: 'l_table_name', 'GMD_CUSTOMER_TESTS',

Line 967: 'l_table_name', 'GMD_CUSTOMER_TESTS',

963: IF NOT GMD_CUSTOMER_TESTS_PVT.LOCK_ROW(
964: p_test_id => l_qc_cust_tests_rec.test_id,
965: p_cust_id => l_qc_cust_tests_rec.cust_id) THEN
966: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
967: 'l_table_name', 'GMD_CUSTOMER_TESTS',
968: 'l_column_name','CUST_ID',
969: 'l_key_value', l_qc_cust_tests_rec.cust_id);
970: RAISE FND_API.G_EXC_ERROR;
971: END IF;

Line 975: IF NOT GMD_CUSTOMER_TESTS_PVT.DELETE_ROW(

971: END IF;
972:
973: -- Now Delete Row
974:
975: IF NOT GMD_CUSTOMER_TESTS_PVT.DELETE_ROW(
976: p_test_id => l_qc_cust_tests_rec.test_id,
977: p_cust_id => l_qc_cust_tests_rec.cust_id) THEN
978:
979: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

Line 980: 'l_table_name', 'GMD_CUSTOMER_TESTS',

976: p_test_id => l_qc_cust_tests_rec.test_id,
977: p_cust_id => l_qc_cust_tests_rec.cust_id) THEN
978:
979: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
980: 'l_table_name', 'GMD_CUSTOMER_TESTS',
981: 'l_column_name','CUST_ID',
982: 'l_key_value', l_qc_cust_tests_rec.cust_id);
983:
984: RAISE FND_API.G_EXC_ERROR;