eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_POLICY_UTILS dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 6957: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,

6953: | Date Author Description of Changes
6954: | 23-Feb-2010 Dharma Theja Reddy S Created
6955: |
6956: *=======================================================================*/
6957: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
6958: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
6959: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER IS
6960:
6961: l_rule_id oie_dup_detect_rules.RULE_ID%TYPE := NULL;

Line 6958: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,

6954: | 23-Feb-2010 Dharma Theja Reddy S Created
6955: |
6956: *=======================================================================*/
6957: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
6958: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
6959: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER IS
6960:
6961: l_rule_id oie_dup_detect_rules.RULE_ID%TYPE := NULL;
6962: l_rule_set_id oie_dup_detect_rs_summary.RULE_SET_ID%TYPE := NULL;

Line 6959: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER IS

6955: |
6956: *=======================================================================*/
6957: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
6958: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
6959: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER IS
6960:
6961: l_rule_id oie_dup_detect_rules.RULE_ID%TYPE := NULL;
6962: l_rule_set_id oie_dup_detect_rs_summary.RULE_SET_ID%TYPE := NULL;
6963: l_category_code VARCHAR2(30) := NULL;

Line 7095: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,

7091: | Date Author Description of Changes
7092: | 23-Feb-2010 Dharma Theja Reddy S Created
7093: |
7094: *=======================================================================*/
7095: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7096: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
7097: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
7098: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
7099: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2 IS

Line 7096: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,

7092: | 23-Feb-2010 Dharma Theja Reddy S Created
7093: |
7094: *=======================================================================*/
7095: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7096: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
7097: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
7098: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
7099: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2 IS
7100:

Line 7097: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,

7093: |
7094: *=======================================================================*/
7095: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7096: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
7097: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
7098: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
7099: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2 IS
7100:
7101: l_rule_id oie_dup_detect_rules.rule_id%TYPE := NULL;

Line 7098: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,

7094: *=======================================================================*/
7095: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7096: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
7097: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
7098: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
7099: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2 IS
7100:
7101: l_rule_id oie_dup_detect_rules.rule_id%TYPE := NULL;
7102: l_dup_detect_action oie_dup_detect_rules.duplicate_detection_action%TYPE := NULL;

Line 7099: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2 IS

7095: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7096: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
7097: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
7098: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
7099: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2 IS
7100:
7101: l_rule_id oie_dup_detect_rules.rule_id%TYPE := NULL;
7102: l_dup_detect_action oie_dup_detect_rules.duplicate_detection_action%TYPE := NULL;
7103: l_count NUMBER := 0;

Line 7159: FUNCTION getDistLineNumber(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,

7155: | Date Author Description of Changes
7156: | 23-Feb-2010 Dharma Theja Reddy S Created
7157: |
7158: *=======================================================================*/
7159: FUNCTION getDistLineNumber(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7160: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN VARCHAR2 IS
7161:
7162: CURSOR dist_num_cur IS
7163: SELECT distribution_line_number, itemization_parent_id

Line 7160: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN VARCHAR2 IS

7156: | 23-Feb-2010 Dharma Theja Reddy S Created
7157: |
7158: *=======================================================================*/
7159: FUNCTION getDistLineNumber(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7160: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN VARCHAR2 IS
7161:
7162: CURSOR dist_num_cur IS
7163: SELECT distribution_line_number, itemization_parent_id
7164: FROM ap_expense_report_lines_all

Line 7164: FROM ap_expense_report_lines_all

7160: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN VARCHAR2 IS
7161:
7162: CURSOR dist_num_cur IS
7163: SELECT distribution_line_number, itemization_parent_id
7164: FROM ap_expense_report_lines_all
7165: WHERE report_header_id = p_report_header_id
7166: AND (itemization_parent_id IS NULL OR itemization_parent_id <> -1)
7167: ORDER BY distribution_line_number, itemization_parent_id;
7168:

Line 7303: expense_lines_rec ap_expense_report_lines_all%ROWTYPE;

7299: TYPE expense_lines IS REF CURSOR;
7300:
7301: expense_lines_cur expense_lines;
7302:
7303: expense_lines_rec ap_expense_report_lines_all%ROWTYPE;
7304:
7305: l_debug_info VARCHAR2(1000);
7306: current_calling_sequence varchar2(100) := 'performDuplicateDetection';
7307: l_stmt VARCHAR2(2000);

Line 7355: /l_stmt := 'SELECT FROM ap_expense_report_lines_all WHERE (((report_header_id IN

7351: OPEN dup_detect_rule_cur(l_rule_id);
7352: FETCH dup_detect_rule_cur INTO dup_detect_rule_rec;
7353: CLOSE dup_detect_rule_cur;
7354:
7355: /*l_stmt := 'SELECT * FROM ap_expense_report_lines_all WHERE (((report_header_id IN
7356: (SELECT report_header_id FROM ap_expense_report_headers_all WHERE employee_id = ' || p_employee_id ||
7357: ' AND AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(source, workflow_approved_flag, report_header_id)
7358: NOT IN (''REJECTED'', ''SAVED'', ''INPROGRESS'', ''WITHDRAWN''))) AND report_header_id <> ' || p_report_header_id ||
7359: ') OR (report_header_id = ' || p_report_header_id || ' AND distribution_line_number < ' || p_distribution_line_number ||

Line 7364: l_stmt := 'SELECT aerl.* FROM ap_expense_report_lines_all aerl, (SELECT report_header_id FROM ap_expense_report_headers_all

7360: ' AND report_line_id <> ' || p_report_line_id || ')) AND (itemization_parent_id is NULL OR itemization_parent_id <> -1)
7361: AND start_expense_date = ''' || p_start_date || ''' AND category_code = ''' || p_category_code|| '''';*/
7362:
7363: -- Bug# 12992286: Duplicate Detection performance fix
7364: l_stmt := 'SELECT aerl.* FROM ap_expense_report_lines_all aerl, (SELECT report_header_id FROM ap_expense_report_headers_all
7365: WHERE employee_id = ' || p_employee_id || ' AND expense_status_code NOT IN (''REJECTED'', ''SAVED'', ''INPROGRESS'', ''WITHDRAWN'')
7366: UNION ALL SELECT ' || p_report_header_id || ' FROM DUAL) aerh WHERE aerl.report_header_id = aerh.report_header_id
7367: AND (aerl.report_header_id <> ' || p_report_header_id || ' OR (aerl.report_header_id = ' || p_report_header_id || '
7368: AND distribution_line_number < ' || p_distribution_line_number || ' AND report_line_id <> ' || p_report_line_id || '))

Line 7371: OR (''' || p_category_code|| ''' IN (''PER_DIEM'', ''MILEAGE'') AND ((((select start_expense_date from ap_expense_report_lines_all

7367: AND (aerl.report_header_id <> ' || p_report_header_id || ' OR (aerl.report_header_id = ' || p_report_header_id || '
7368: AND distribution_line_number < ' || p_distribution_line_number || ' AND report_line_id <> ' || p_report_line_id || '))
7369: AND (itemization_parent_id is NULL OR itemization_parent_id <> -1) AND category_code = ''' || p_category_code|| '''
7370: AND ((''' || p_category_code|| ''' NOT IN (''PER_DIEM'', ''MILEAGE'') AND start_expense_date = ''' || p_start_date || ''')
7371: OR (''' || p_category_code|| ''' IN (''PER_DIEM'', ''MILEAGE'') AND ((((select start_expense_date from ap_expense_report_lines_all
7372: where report_line_id = ' || p_report_line_id || ') between start_expense_date AND end_expense_date) OR (start_expense_date between
7373: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND
7374: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))';
7375:

Line 7373: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND

7369: AND (itemization_parent_id is NULL OR itemization_parent_id <> -1) AND category_code = ''' || p_category_code|| '''
7370: AND ((''' || p_category_code|| ''' NOT IN (''PER_DIEM'', ''MILEAGE'') AND start_expense_date = ''' || p_start_date || ''')
7371: OR (''' || p_category_code|| ''' IN (''PER_DIEM'', ''MILEAGE'') AND ((((select start_expense_date from ap_expense_report_lines_all
7372: where report_line_id = ' || p_report_line_id || ') between start_expense_date AND end_expense_date) OR (start_expense_date between
7373: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND
7374: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))';
7375:
7376: IF dup_detect_rule_rec.detect_attendee_flag = 'Y' THEN
7377: /*l_att_stmt := 'SELECT * FROM ap_expense_report_lines_all WHERE (((report_header_id IN

Line 7374: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))';

7370: AND ((''' || p_category_code|| ''' NOT IN (''PER_DIEM'', ''MILEAGE'') AND start_expense_date = ''' || p_start_date || ''')
7371: OR (''' || p_category_code|| ''' IN (''PER_DIEM'', ''MILEAGE'') AND ((((select start_expense_date from ap_expense_report_lines_all
7372: where report_line_id = ' || p_report_line_id || ') between start_expense_date AND end_expense_date) OR (start_expense_date between
7373: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND
7374: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))';
7375:
7376: IF dup_detect_rule_rec.detect_attendee_flag = 'Y' THEN
7377: /*l_att_stmt := 'SELECT * FROM ap_expense_report_lines_all WHERE (((report_header_id IN
7378: (SELECT report_header_id FROM ap_expense_report_headers_all

Line 7377: /l_att_stmt := 'SELECT FROM ap_expense_report_lines_all WHERE (((report_header_id IN

7373: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND
7374: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))';
7375:
7376: IF dup_detect_rule_rec.detect_attendee_flag = 'Y' THEN
7377: /*l_att_stmt := 'SELECT * FROM ap_expense_report_lines_all WHERE (((report_header_id IN
7378: (SELECT report_header_id FROM ap_expense_report_headers_all
7379: WHERE AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(source, workflow_approved_flag, report_header_id)
7380: NOT IN (''REJECTED'', ''SAVED'', ''INPROGRESS'', ''WITHDRAWN''))) AND report_header_id <> ' || p_report_header_id ||
7381: ') OR (report_header_id = ' || p_report_header_id || ' AND distribution_line_number < ' || p_distribution_line_number ||

Line 7387: l_att_stmt := 'SELECT aerl.* FROM ap_expense_report_lines_all aerl, (SELECT report_header_id FROM ap_expense_report_headers_all

7383: AND start_expense_date = ''' || p_start_date || ''' AND category_code = ''' || p_category_code|| '''
7384: AND EXISTS (SELECT 1 FROM oie_attendees_all atts WHERE atts.report_line_id = report_line_id AND
7385: atts.employee_flag = ''Y'' AND atts.employee_id = ' || p_employee_id || ')';*/
7386:
7387: l_att_stmt := 'SELECT aerl.* FROM ap_expense_report_lines_all aerl, (SELECT report_header_id FROM ap_expense_report_headers_all
7388: WHERE expense_status_code NOT IN (''REJECTED'', ''SAVED'', ''INPROGRESS'', ''WITHDRAWN'')
7389: UNION ALL SELECT ' || p_report_header_id || ' FROM DUAL) aerh WHERE aerl.report_header_id = aerh.report_header_id
7390: AND (aerl.report_header_id <> ' || p_report_header_id || ' OR (aerl.report_header_id = ' || p_report_header_id || '
7391: AND distribution_line_number < ' || p_distribution_line_number || ' AND report_line_id <> ' || p_report_line_id || '))

Line 7394: OR (''' || p_category_code|| ''' IN (''PER_DIEM'', ''MILEAGE'') AND ((((select start_expense_date from ap_expense_report_lines_all

7390: AND (aerl.report_header_id <> ' || p_report_header_id || ' OR (aerl.report_header_id = ' || p_report_header_id || '
7391: AND distribution_line_number < ' || p_distribution_line_number || ' AND report_line_id <> ' || p_report_line_id || '))
7392: AND (itemization_parent_id is NULL OR itemization_parent_id <> -1) AND category_code = ''' || p_category_code|| '''
7393: AND ((''' || p_category_code|| ''' NOT IN (''PER_DIEM'', ''MILEAGE'') AND start_expense_date = ''' || p_start_date || ''')
7394: OR (''' || p_category_code|| ''' IN (''PER_DIEM'', ''MILEAGE'') AND ((((select start_expense_date from ap_expense_report_lines_all
7395: where report_line_id = ' || p_report_line_id || ') between start_expense_date AND end_expense_date) OR (start_expense_date between
7396: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND
7397: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))
7398: AND EXISTS (SELECT 1 FROM oie_attendees_all atts WHERE atts.report_line_id = aerl.report_line_id

Line 7396: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND

7392: AND (itemization_parent_id is NULL OR itemization_parent_id <> -1) AND category_code = ''' || p_category_code|| '''
7393: AND ((''' || p_category_code|| ''' NOT IN (''PER_DIEM'', ''MILEAGE'') AND start_expense_date = ''' || p_start_date || ''')
7394: OR (''' || p_category_code|| ''' IN (''PER_DIEM'', ''MILEAGE'') AND ((((select start_expense_date from ap_expense_report_lines_all
7395: where report_line_id = ' || p_report_line_id || ') between start_expense_date AND end_expense_date) OR (start_expense_date between
7396: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND
7397: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))
7398: AND EXISTS (SELECT 1 FROM oie_attendees_all atts WHERE atts.report_line_id = aerl.report_line_id
7399: AND atts.employee_flag = ''Y'' AND atts.employee_id = ' || p_employee_id || ')';
7400:

Line 7397: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))

7393: AND ((''' || p_category_code|| ''' NOT IN (''PER_DIEM'', ''MILEAGE'') AND start_expense_date = ''' || p_start_date || ''')
7394: OR (''' || p_category_code|| ''' IN (''PER_DIEM'', ''MILEAGE'') AND ((((select start_expense_date from ap_expense_report_lines_all
7395: where report_line_id = ' || p_report_line_id || ') between start_expense_date AND end_expense_date) OR (start_expense_date between
7396: (select start_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || ') AND
7397: (select end_expense_date from ap_expense_report_lines_all where report_line_id = ' || p_report_line_id || '))))))
7398: AND EXISTS (SELECT 1 FROM oie_attendees_all atts WHERE atts.report_line_id = aerl.report_line_id
7399: AND atts.employee_flag = ''Y'' AND atts.employee_id = ' || p_employee_id || ')';
7400:
7401: OPEN expense_lines_cur FOR l_att_stmt;

Line 7425: l_where_clause := l_where_clause || ' AND receipt_currency_amount IN (SELECT receipt_currency_amount FROM ap_expense_report_lines_all

7421: END IF;
7422: END IF;
7423:
7424: IF dup_detect_rule_rec.detect_receipt_amt_flag = 'Y' THEN
7425: l_where_clause := l_where_clause || ' AND receipt_currency_amount IN (SELECT receipt_currency_amount FROM ap_expense_report_lines_all
7426: WHERE report_line_id = ' || p_report_line_id || ') AND receipt_currency_code = ''' || p_receipt_currency_code || '''';
7427: END IF;
7428:
7429: IF dup_detect_rule_rec.rule_type <> 'GENERIC' THEN

Line 7586: PROCEDURE removeDupViolations(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,

7582: | Date Author Description of Changes
7583: | 23-Feb-2010 Dharma Theja Reddy S Created
7584: |
7585: *=======================================================================*/
7586: PROCEDURE removeDupViolations(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7587: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) IS
7588:
7589: BEGIN
7590:

Line 7587: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) IS

7583: | 23-Feb-2010 Dharma Theja Reddy S Created
7584: |
7585: *=======================================================================*/
7586: PROCEDURE removeDupViolations(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
7587: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) IS
7588:
7589: BEGIN
7590:
7591: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_POLICY_UTILS', 'start removeDupViolations');

Line 7626: dist_lines_rec ap_expense_report_lines_all%ROWTYPE;

7622: p_dist_num OUT NOCOPY VARCHAR2) IS
7623:
7624: TYPE dist_lines IS REF CURSOR;
7625: dist_lines_cur dist_lines;
7626: dist_lines_rec ap_expense_report_lines_all%ROWTYPE;
7627:
7628: l_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE;
7629: l_category_code ap_expense_report_lines_all.CATEGORY_CODE%TYPE;
7630: l_credit_card_trx_id ap_expense_report_lines_all.CREDIT_CARD_TRX_ID%TYPE;

Line 7628: l_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE;

7624: TYPE dist_lines IS REF CURSOR;
7625: dist_lines_cur dist_lines;
7626: dist_lines_rec ap_expense_report_lines_all%ROWTYPE;
7627:
7628: l_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE;
7629: l_category_code ap_expense_report_lines_all.CATEGORY_CODE%TYPE;
7630: l_credit_card_trx_id ap_expense_report_lines_all.CREDIT_CARD_TRX_ID%TYPE;
7631: l_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE;
7632: l_stmt VARCHAR2(2000);

Line 7629: l_category_code ap_expense_report_lines_all.CATEGORY_CODE%TYPE;

7625: dist_lines_cur dist_lines;
7626: dist_lines_rec ap_expense_report_lines_all%ROWTYPE;
7627:
7628: l_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE;
7629: l_category_code ap_expense_report_lines_all.CATEGORY_CODE%TYPE;
7630: l_credit_card_trx_id ap_expense_report_lines_all.CREDIT_CARD_TRX_ID%TYPE;
7631: l_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE;
7632: l_stmt VARCHAR2(2000);
7633: l_primary_number NUMBER := 0;

Line 7630: l_credit_card_trx_id ap_expense_report_lines_all.CREDIT_CARD_TRX_ID%TYPE;

7626: dist_lines_rec ap_expense_report_lines_all%ROWTYPE;
7627:
7628: l_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE;
7629: l_category_code ap_expense_report_lines_all.CATEGORY_CODE%TYPE;
7630: l_credit_card_trx_id ap_expense_report_lines_all.CREDIT_CARD_TRX_ID%TYPE;
7631: l_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE;
7632: l_stmt VARCHAR2(2000);
7633: l_primary_number NUMBER := 0;
7634: l_sub_number NUMBER := 0;

Line 7631: l_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE;

7627:
7628: l_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE;
7629: l_category_code ap_expense_report_lines_all.CATEGORY_CODE%TYPE;
7630: l_credit_card_trx_id ap_expense_report_lines_all.CREDIT_CARD_TRX_ID%TYPE;
7631: l_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE;
7632: l_stmt VARCHAR2(2000);
7633: l_primary_number NUMBER := 0;
7634: l_sub_number NUMBER := 0;
7635: l_prev_parent_id NUMBER := 0;

Line 7648: FROM ap_expense_report_lines_all WHERE report_line_id = p_report_line_id;

7644: END IF;
7645:
7646: SELECT report_header_id, category_code, credit_card_trx_id, distribution_line_number
7647: INTO l_report_header_id, l_category_code, l_credit_card_trx_id, l_dist_line_number
7648: FROM ap_expense_report_lines_all WHERE report_line_id = p_report_line_id;
7649:
7650: IF l_category_code = 'PER_DIEM' OR l_category_code = 'MILEAGE' THEN
7651: p_category := l_category_code;
7652: l_stmt := 'SELECT * FROM ap_expense_report_lines_all

Line 7652: l_stmt := 'SELECT * FROM ap_expense_report_lines_all

7648: FROM ap_expense_report_lines_all WHERE report_line_id = p_report_line_id;
7649:
7650: IF l_category_code = 'PER_DIEM' OR l_category_code = 'MILEAGE' THEN
7651: p_category := l_category_code;
7652: l_stmt := 'SELECT * FROM ap_expense_report_lines_all
7653: WHERE report_header_id = ' || l_report_header_id || ' AND category_code = ''' || l_category_code ||
7654: ''' ORDER by distribution_line_number, itemization_parent_id';
7655: ELSE
7656: IF l_credit_card_trx_id IS NOT NULL THEN

Line 7658: l_stmt := 'SELECT * FROM ap_expense_report_lines_all

7654: ''' ORDER by distribution_line_number, itemization_parent_id';
7655: ELSE
7656: IF l_credit_card_trx_id IS NOT NULL THEN
7657: p_category := 'CREDIT';
7658: l_stmt := 'SELECT * FROM ap_expense_report_lines_all
7659: WHERE report_header_id = ' || l_report_header_id || ' AND credit_card_trx_id IS NOT NULL
7660: AND (itemization_parent_id IS NULL OR itemization_parent_id <> -1) AND category_code NOT IN (''PER_DIEM'', ''MILEAGE'')
7661: ORDER by distribution_line_number, itemization_parent_id';
7662: ELSE

Line 7664: l_stmt := 'SELECT * FROM ap_expense_report_lines_all

7660: AND (itemization_parent_id IS NULL OR itemization_parent_id <> -1) AND category_code NOT IN (''PER_DIEM'', ''MILEAGE'')
7661: ORDER by distribution_line_number, itemization_parent_id';
7662: ELSE
7663: p_category := 'CASH';
7664: l_stmt := 'SELECT * FROM ap_expense_report_lines_all
7665: WHERE report_header_id = ' || l_report_header_id || ' AND credit_card_trx_id IS NULL
7666: AND (itemization_parent_id IS NULL OR itemization_parent_id <> -1) AND category_code NOT IN (''PER_DIEM'', ''MILEAGE'')
7667: ORDER by distribution_line_number, itemization_parent_id';
7668: END IF;