[Home] [Help]
67: -- performed by the API.
68: -- values - G_RET_STS_SUCESS = 'S'
69: -- G_RET_STS_ERROR = 'E'
70: -- G_RET_STS_UNEXP_ERROR = 'U'
71: -- : p_interface_obj IN OUT gms_po_interface_type
72: -- SQL object that holds the value of distribution_ID,
73: -- distribution number, project, task, award set id
74: -- for bulk processing.
75: -- End of comments
78: (
79: x_msg_count out nocopy number,
80: x_msg_data out nocopy varchar2,
81: x_return_status out nocopy varchar2,
82: p_interface_obj in out nocopy gms_po_interface_type) is
83:
84: l_dummy NUMBER ;
85: BEGIN
86:
408: -- p_api_version, p_commit, p_init_msg_list,
409: -- p_validation_level, x_msg_count, x_msg_data,
410: -- x_return_status
411: -- IN OUT
412: -- : p_interface_obj gms_po_interface_type
413: -- This is a SQL object having a following table
414: -- elements.
415: -- distribution_id - Holds distribution ID
416: -- distribution_num Holds distribution number
430: p_validation_level in number,
431: x_msg_count out nocopy number,
432: x_msg_data out nocopy varchar2,
433: x_return_status out nocopy varchar2,
434: p_interface_obj in out nocopy gms_po_interface_type) is
435:
436: l_msg_count number ;
437: l_msg_data varchar2(2000) ;
438: l_return_status varchar2(1) ;
521: -- p_api_version, p_commit, p_init_msg_list,
522: -- p_validation_level, x_msg_count, x_msg_data,
523: -- x_return_status
524: -- IN OUT
525: -- : p_interface_obj gms_po_interface_type
526: -- This is a SQL object having a following table
527: -- elements.
528: -- distribution_id - Holds distribution ID
529: -- distribution_num Holds distribution number
542: p_validation_level in number,
543: x_msg_count out nocopy number,
544: x_msg_data out nocopy varchar2,
545: x_return_status out nocopy varchar2,
546: p_interface_obj in out nocopy gms_po_interface_type) is
547:
548: l_msg_count NUMBER ;
549: l_msg_data varchar2(2000) ;
550: l_return_status varchar2(1) ;