DBA Data[Home] [Help]

APPS.CSD_RECEIVE_PVT dependencies on CSD_RECEIVE_UTIL

Line 25: p_receive_tbl IN csd_receive_util.rcv_tbl_type,

21: )
22: RETURN BOOLEAN;
23:
24: PROCEDURE dump_receive_tbl (
25: p_receive_tbl IN csd_receive_util.rcv_tbl_type,
26: p_level NUMBER,
27: p_module VARCHAR2
28: );
29:

Line 45: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */

41: /* fnd_api.g_false */
42: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
43: /* validation steps must be done and which steps */
44: /* should be skipped. */
45: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
46: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
47: /* fnd_api.g_ret_sts_success (success) */
48: /* fnd_api.g_ret_sts_error (error) */
49: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

Line 62: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,

58: p_validation_level IN NUMBER,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,
63: p_receive_tbl IN OUT NOCOPY csd_receive_util.rcv_tbl_type
64: )
65: IS
66: l_api_version_number CONSTANT NUMBER := 1.0;

Line 63: p_receive_tbl IN OUT NOCOPY csd_receive_util.rcv_tbl_type

59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,
63: p_receive_tbl IN OUT NOCOPY csd_receive_util.rcv_tbl_type
64: )
65: IS
66: l_api_version_number CONSTANT NUMBER := 1.0;
67: l_api_name CONSTANT VARCHAR2 (30) := 'RECEIVE_ITEM';

Line 121: csd_receive_util.validate_rcv_input

117: END IF;
118: -------------Validate Input data.
119: FOR l_index IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
120: LOOP
121: csd_receive_util.validate_rcv_input
122: (p_validation_level => fnd_api.g_valid_level_full,
123: x_return_status => x_return_status,
124: p_receive_rec => p_receive_tbl (l_index)
125: );

Line 132: csd_receive_util.is_auto_rcv_available

128: RAISE fnd_api.g_exc_error;
129: END IF;
130:
131: p_receive_tbl (l_index).routing_header_id :=
132: csd_receive_util.is_auto_rcv_available
133: (p_receive_tbl (l_index).inventory_item_id,
134: p_receive_tbl (l_index).to_organization_id,
135: p_receive_tbl (l_index).internal_order_flag,
136: p_receive_tbl (l_index).from_organization_id

Line 207: csd_receive_util.check_rcv_errors

203: );
204: END IF;
205:
206: --Call Check_Rcv_Errors to check the errors in the PO_INTERFACE_ERRORS table.
207: csd_receive_util.check_rcv_errors
208: (x_return_status => x_return_status,
209: x_rcv_error_msg_tbl => x_rcv_error_msg_tbl,
210: p_request_group_id => l_request_group_id
211: );

Line 323: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */

319: /* fnd_api.g_false */
320: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
321: /* validation steps must be done and which steps */
322: /* should be skipped. */
323: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
324: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
325: /* fnd_api.g_ret_sts_success (success) */
326: /* fnd_api.g_ret_sts_error (error) */
327: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

Line 339: p_receive_tbl IN csd_receive_util.rcv_tbl_type,

335: p_validation_level IN NUMBER,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,
339: p_receive_tbl IN csd_receive_util.rcv_tbl_type,
340: x_request_group_id OUT NOCOPY NUMBER
341: )
342: IS
343: pragma AUTONOMOUS_TRANSACTION;

Line 349: p_receive_rec csd_receive_util.rcv_rec_type;

345: l_api_name CONSTANT VARCHAR2 (30)
346: := 'Populate_Rcv_Intf_Tbls';
347: l_hdr_intf_id NUMBER;
348: i NUMBER;
349: p_receive_rec csd_receive_util.rcv_rec_type;
350: l_source_code VARCHAR2 (240);
351: l_source_line_id NUMBER := 1;
352: l_txn_tmp_id NUMBER;
353: l_source_header_id NUMBER := 1;

Line 509: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);

505: 'Inserting transactions interface table data'
506: );
507: END IF;
508:
509: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);
510:
511: --Insert data into the transactions interface table.
512: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
513: LOOP

Line 516: csd_receive_util.get_rcv_item_params (p_receive_rec);

512: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
513: LOOP
514: p_receive_rec := p_receive_tbl (i);
515: p_receive_rec.employee_id := l_emp_id;
516: csd_receive_util.get_rcv_item_params (p_receive_rec);
517:
518: -- Derive the Org id
519: -- MOAC change Bug#4245577
520: OPEN c_get_org_id (p_receive_rec.order_line_id);

Line 1617: p_receive_tbl IN csd_receive_util.rcv_tbl_type,

1613: /****************************************************************
1614: Dupms the input receive table records in to log
1615: *****************************************************************/
1616: PROCEDURE dump_receive_tbl (
1617: p_receive_tbl IN csd_receive_util.rcv_tbl_type,
1618: p_level NUMBER,
1619: p_module VARCHAR2
1620: )
1621: IS