DBA Data[Home] [Help]

APPS.PO_AUTO_DIST_PROCESS_PVT dependencies on PO_DISTRIBUTIONS_S

Line 393: SET po_distribution_id = po_distributions_s.NEXTVAL,

389:
390: l_progress := '190';
391: --update po_distributions interface
392: UPDATE po_distributions_interface
393: SET po_distribution_id = po_distributions_s.NEXTVAL,
394: distribution_num = x_distribution_num + rownum
395: WHERE interface_header_id = p_lines.intf_header_id_tbl(i)
396: AND interface_line_id = p_lines.intf_line_id_tbl(i);
397:

Line 1069: SELECT PO_DISTRIBUTIONS_S.NEXTVAL ,

1065: quantity_funded,
1066: amount_funded ,
1067: change_in_funded_value
1068: )
1069: SELECT PO_DISTRIBUTIONS_S.NEXTVAL ,
1070: po_autocreate_params.g_draft_id ,
1071: p_lines.last_update_date_tbl(i) ,
1072: p_lines.last_updated_by_tbl(i) ,
1073: p_lines.last_update_login_tbl(i) ,

Line 1262: SELECT PO_DISTRIBUTIONS_S.NEXTVAL ,

1258: quantity_funded ,
1259: amount_funded ,
1260: change_in_funded_value
1261: )
1262: SELECT PO_DISTRIBUTIONS_S.NEXTVAL ,
1263: po_autocreate_params.g_draft_id ,
1264: p_lines.last_update_date_tbl(i) ,
1265: p_lines.last_updated_by_tbl(i) ,
1266: p_lines.last_update_login_tbl(i) ,

Line 1386: SELECT PO_DISTRIBUTIONS_S.NEXTVAL ,

1382: expenditure_item_date ,
1383: set_of_books_id ,
1384: tax_attribute_update_code --
1385: )
1386: SELECT PO_DISTRIBUTIONS_S.NEXTVAL ,
1387: po_autocreate_params.g_draft_id ,
1388: p_lines.last_update_date_tbl(i) ,
1389: p_lines.last_updated_by_tbl(i) ,
1390: p_lines.last_update_login_tbl(i) ,