[Home] [Help]
271: FROM ap_invoices_interface
272: WHERE ((status is NULL) OR (status = 'REJECTED'))
273: AND source = p_source
274: AND ((p_invoice_interface_id IS NULL AND
275: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
276: OR (invoice_id = p_invoice_interface_id))
277: AND NVL(workflow_flag,'D') = 'D'
278: AND ( (p_commit_cycles IS NULL)
279: OR (rownum <= p_commit_cycles))
476: WHERE ((status is NULL) OR (status = 'REJECTED'))
477: AND source = p_source
478: AND group_id = p_group_id
479: AND ((p_invoice_interface_id IS NULL AND
480: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
481: OR (invoice_id = p_invoice_interface_id))
482: AND NVL(workflow_flag,'D') = 'D'
483: AND ( (p_commit_cycles IS NULL)
484: OR (rownum <= p_commit_cycles))
888: l_stmt := l_stmt || ' AND group_id = '''|| p_group_id || ''' ';
889: END IF;
890:
891: IF p_invoice_interface_id IS NULL THEN
892: l_stmt := l_stmt || ' AND NVL(invoice_type_lookup_code, ''STANDARD'') <> ''PAYMENT REQUEST'' ';
893: ELSE
894: l_stmt := l_stmt || ' AND invoice_id = ' || p_invoice_interface_id || ' ';
895: END IF;
896:
910: FROM ap_invoices_interface
911: WHERE ((status is NULL) or (status = 'REJECTED'))
912: AND source = p_source
913: AND ((p_invoice_interface_id IS NULL AND
914: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
915: OR (invoice_id = p_invoice_interface_id))
916: AND nvl(workflow_flag,'D') = 'D'
917: AND ((org_id is NOT NULL AND
918: p_org_id is NOT NULL AND
931: WHERE ((status is NULL) or (status = 'REJECTED'))
932: AND source = p_source
933: AND group_id = p_group_id
934: AND ((p_invoice_interface_id IS NULL AND
935: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
936: OR (invoice_id = p_invoice_interface_id))
937: AND nvl(workflow_flag,'D') = 'D'
938: AND ((org_id is NOT NULL AND
939: p_org_id is NOT NULL AND
1028: l_stmt := l_stmt || ' AND group_id = ''' || p_group_id || ''' ';
1029: END IF;
1030:
1031: IF p_invoice_interface_id IS NULL THEN
1032: l_stmt := l_stmt || ' AND NVL(invoice_type_lookup_code, ''STANDARD'') <> ''PAYMENT REQUEST'' ';
1033: ELSE
1034: l_stmt := l_stmt || ' AND invoice_id = ' || p_invoice_interface_id || ' ';
1035: END IF;
1036:
1048: AND i.operating_unit is not null
1049: AND ((status is NULL) OR (status = 'REJECTED'))
1050: AND source = p_source
1051: AND ((p_invoice_interface_id IS NULL AND
1052: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
1053: OR (invoice_id = p_invoice_interface_id))
1054: AND NVL(workflow_flag,'D') = 'D' ;
1055:
1056: --Bug 6839034 Added ELSE part
1068: AND ((status is NULL) OR (status = 'REJECTED'))
1069: AND source = p_source
1070: AND group_id = p_group_id
1071: AND ((p_invoice_interface_id IS NULL AND
1072: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
1073: OR (invoice_id = p_invoice_interface_id))
1074: AND NVL(workflow_flag,'D') = 'D' ;
1075:
1076: END IF;
1116: l_stmt := l_stmt || ' AND group_id = ''' || p_group_id || ''' ';
1117: END IF;
1118:
1119: IF p_invoice_interface_id IS NULL THEN
1120: l_stmt := l_stmt || ' AND NVL(invoice_type_lookup_code, ''STANDARD'') <> ''PAYMENT REQUEST'' ';
1121: ELSE
1122: l_stmt := l_stmt || ' AND invoice_id = ' || p_invoice_interface_id || ' ';
1123: END IF;
1124:
1174: FROM ap_invoices_interface
1175: WHERE ((status is NULL) or (status = 'REJECTED'))
1176: AND source = p_source
1177: AND ((p_invoice_interface_id IS NULL AND
1178: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
1179: OR (invoice_id = p_invoice_interface_id))
1180: AND nvl(workflow_flag,'D') = 'D'
1181: AND ((org_id is NOT NULL AND
1182: p_org_id is NOT NULL AND
1207: WHERE ((status is NULL) or (status = 'REJECTED'))
1208: AND source = p_source
1209: AND group_id = p_group_id
1210: AND ((p_invoice_interface_id IS NULL AND
1211: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
1212: OR (invoice_id = p_invoice_interface_id))
1213: AND nvl(workflow_flag,'D') = 'D'
1214: AND ((org_id is NOT NULL AND
1215: p_org_id is NOT NULL AND