[Home] [Help]
46: INDEX BY BINARY_INTEGER;
47:
48: -- ----------------------------------------------------------------------------+
49: -- Procedure: validate_calc_sub_batch
50: -- Desc : check if the record is valid to insert into cn_calc_submission_batches
51: -- ----------------------------------------------------------------------------+
52: PROCEDURE validate_calc_sub_batch
53: (
54: x_return_status OUT NOCOPY VARCHAR2,
76: l_counter number := 0;
77:
78: CURSOR l_batch_name_csr IS
79: SELECT COUNT(*)
80: FROM cn_calc_submission_batches_all
81: WHERE name = p_calc_submission_rec.batch_name
82: AND org_id = g_org_id;
83: BEGIN
84: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
674:
675:
676: -- ----------------------------------------------------------------------------+
677: -- Procedure: validate_bonus_pe_entries
678: -- Desc : check if the record is valid to insert into cn_calc_submission_batches
679: -- ----------------------------------------------------------------------------+
680: PROCEDURE validate_bonus_pe_entries
681: (
682: x_return_status OUT NOCOPY VARCHAR2,
772: END validate_bonus_pe_entries;
773:
774: -- ----------------------------------------------------------------------------+
775: -- Procedure: validate_app_user_resp
776: -- Desc : check if the record is valid to insert into cn_calc_submission_batches
777: -- ----------------------------------------------------------------------------+
778: PROCEDURE validate_app_user_resp
779: ( x_return_status OUT NOCOPY VARCHAR2,
780: x_msg_count OUT NOCOPY NUMBER,
944:
945: FUNCTION get_calc_sub_batch_status ( p_calc_sub_batch_id NUMBER) RETURN VARCHAR2 IS
946: CURSOR l_status_csr IS
947: SELECT status
948: FROM cn_calc_submission_batches_all
949: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
950:
951: x_status VARCHAR2(30);
952:
1057: l_user_id NUMBER;
1058: l_responsibility_id NUMBER;
1059: l_unfinished BOOLEAN := TRUE;
1060:
1061: l_calc_sub_status cn_calc_submission_batches.status%TYPE;
1062: l_process_audit_id NUMBER;
1063: l_process_audit_status VARCHAR2(30);
1064:
1065: l_bind_data_id NUMBER;
1251: END IF;
1252:
1253: END IF;
1254:
1255: -- insert into cn_calc_submission_batches
1256: cn_calc_sub_batches_pkg.begin_record
1257: ( p_operation => 'INSERT',
1258: p_calc_sub_batch_id => l_calc_sub_batch_id,
1259: p_name => l_p_calc_submission_rec.batch_name,
1637: l_user_id NUMBER;
1638: l_responsibility_id NUMBER;
1639: l_unfinished BOOLEAN := TRUE;
1640:
1641: l_calc_sub_status cn_calc_submission_batches.status%TYPE;
1642: l_process_audit_id NUMBER;
1643: l_process_audit_status VARCHAR2(30);
1644: l_status VARCHAR2(30);
1645:
1642: l_process_audit_id NUMBER;
1643: l_process_audit_status VARCHAR2(30);
1644: l_status VARCHAR2(30);
1645:
1646: CURSOR l_calc_sub_batch_csr( l_name cn_calc_submission_batches.name%TYPE)
1647: IS
1648: SELECT *
1649: FROM cn_calc_submission_batches_all
1650: WHERE name = l_name
1645:
1646: CURSOR l_calc_sub_batch_csr( l_name cn_calc_submission_batches.name%TYPE)
1647: IS
1648: SELECT *
1649: FROM cn_calc_submission_batches_all
1650: WHERE name = l_name
1651: AND org_id = g_org_id;
1652:
1653: l_calc_sub_batch_rec l_calc_sub_batch_csr%ROWTYPE;
2069: l_interval_type_id := -1003;
2070: END IF;
2071: END IF;
2072:
2073: -- update cn_calc_submission_batches
2074: cn_calc_sub_batches_pkg.begin_record
2075: ( p_operation => 'UPDATE',
2076: p_calc_sub_batch_id => l_calc_sub_batch_id,
2077: p_name => l_p_calc_submission_rec.batch_name,