7: /* to do the validations */
8: /*----------------------------------------------------------*/
9:
10: TYPE txn_line_dtl_rec is RECORD
11: ( txn_line_detail_id NUMBER := FND_API.G_MISS_NUM );
12:
13: TYPE txn_line_dtl_tbl is TABLE OF txn_line_dtl_rec INDEX BY BINARY_INTEGER;
14:
15: TYPE txn_ps_rec is RECORD(
12:
13: TYPE txn_line_dtl_tbl is TABLE OF txn_line_dtl_rec INDEX BY BINARY_INTEGER;
14:
15: TYPE txn_ps_rec is RECORD(
16: txn_line_detail_id number := fnd_api.g_miss_num,
17: transaction_line_id number := fnd_api.g_miss_num,
18: processed_flag varchar2(1) := fnd_api.g_miss_char,
19: quantity number := fnd_api.g_miss_num,
20: quantity_ratio number := fnd_api.g_miss_num,
13: TYPE txn_line_dtl_tbl is TABLE OF txn_line_dtl_rec INDEX BY BINARY_INTEGER;
14:
15: TYPE txn_ps_rec is RECORD(
16: txn_line_detail_id number := fnd_api.g_miss_num,
17: transaction_line_id number := fnd_api.g_miss_num,
18: processed_flag varchar2(1) := fnd_api.g_miss_char,
19: quantity number := fnd_api.g_miss_num,
20: quantity_ratio number := fnd_api.g_miss_num,
21: quantity_remaining number := fnd_api.g_miss_num);
14:
15: TYPE txn_ps_rec is RECORD(
16: txn_line_detail_id number := fnd_api.g_miss_num,
17: transaction_line_id number := fnd_api.g_miss_num,
18: processed_flag varchar2(1) := fnd_api.g_miss_char,
19: quantity number := fnd_api.g_miss_num,
20: quantity_ratio number := fnd_api.g_miss_num,
21: quantity_remaining number := fnd_api.g_miss_num);
22:
15: TYPE txn_ps_rec is RECORD(
16: txn_line_detail_id number := fnd_api.g_miss_num,
17: transaction_line_id number := fnd_api.g_miss_num,
18: processed_flag varchar2(1) := fnd_api.g_miss_char,
19: quantity number := fnd_api.g_miss_num,
20: quantity_ratio number := fnd_api.g_miss_num,
21: quantity_remaining number := fnd_api.g_miss_num);
22:
23: TYPE txn_ps_tbl IS TABLE OF txn_ps_rec INDEX BY binary_integer;
16: txn_line_detail_id number := fnd_api.g_miss_num,
17: transaction_line_id number := fnd_api.g_miss_num,
18: processed_flag varchar2(1) := fnd_api.g_miss_char,
19: quantity number := fnd_api.g_miss_num,
20: quantity_ratio number := fnd_api.g_miss_num,
21: quantity_remaining number := fnd_api.g_miss_num);
22:
23: TYPE txn_ps_tbl IS TABLE OF txn_ps_rec INDEX BY binary_integer;
24:
17: transaction_line_id number := fnd_api.g_miss_num,
18: processed_flag varchar2(1) := fnd_api.g_miss_char,
19: quantity number := fnd_api.g_miss_num,
20: quantity_ratio number := fnd_api.g_miss_num,
21: quantity_remaining number := fnd_api.g_miss_num);
22:
23: TYPE txn_ps_tbl IS TABLE OF txn_ps_rec INDEX BY binary_integer;
24:
25: FUNCTION Entitledcontracts (