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.CSP_EXCESS_PARTS_PVT dependencies on CSP_EXCESS_LISTS_PKG

Line 113: v_excess_part CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;

109: l_excess_rule_id number;
110: L_LOC_ASSIGNMENT_ID number;
111:
112: -- bug # 8518127
113: v_excess_part CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
114: CURSOR employee_id_cur IS
115: SELECT employee_id
116: FROM fnd_user
117: WHERE user_id = l_user_id;

Line 515: csp_excess_lists_pkg.Insert_Row(

511: NVL(inv_rec.TOT_AVAIL_QTY,0) - NVL(inv_rec.SUPPLY_QTY,0) - NVL(inv_rec.MAX_QTY,0));
512: else
513: x_excess_line_id := null;
514: /*
515: csp_excess_lists_pkg.Insert_Row(
516: px_EXCESS_LINE_ID => x_excess_line_id,
517: p_CREATED_BY => fnd_global.user_id,
518: p_CREATION_DATE => sysdate,
519: p_LAST_UPDATED_BY => fnd_global.user_id,

Line 550: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;

546: p_ATTRIBUTE15 => null);
547: */
548:
549:
550: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
551: v_excess_part.CREATED_BY := fnd_global.user_id;
552: v_excess_part.CREATION_DATE := sysdate;
553: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
554: v_excess_part.LAST_UPDATE_DATE := sysdate;

Line 637: csp_excess_lists_pkg.Insert_Row(

633: l_excess);
634: else
635: x_excess_line_id := null;
636: /*
637: csp_excess_lists_pkg.Insert_Row(
638: px_EXCESS_LINE_ID => x_excess_line_id,
639: p_CREATED_BY => fnd_global.user_id,
640: p_CREATION_DATE => sysdate,
641: p_LAST_UPDATED_BY => fnd_global.user_id,

Line 671: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;

667: p_ATTRIBUTE14 => null,
668: p_ATTRIBUTE15 => null);
669: */
670:
671: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
672: v_excess_part.CREATED_BY := fnd_global.user_id;
673: v_excess_part.CREATION_DATE := sysdate;
674: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
675: v_excess_part.LAST_UPDATE_DATE := sysdate;

Line 749: csp_excess_lists_pkg.Insert_Row(

745: l_excess);
746: else
747: x_excess_line_id := null;
748: /*
749: csp_excess_lists_pkg.Insert_Row(
750: px_EXCESS_LINE_ID => x_excess_line_id,
751: p_CREATED_BY => fnd_global.user_id,
752: p_CREATION_DATE => sysdate,
753: p_LAST_UPDATED_BY => fnd_global.user_id,

Line 783: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;

779: p_ATTRIBUTE14 => null,
780: p_ATTRIBUTE15 => null);
781: */
782:
783: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
784: v_excess_part.CREATED_BY := fnd_global.user_id;
785: v_excess_part.CREATION_DATE := sysdate;
786: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
787: v_excess_part.LAST_UPDATE_DATE := sysdate;

Line 1137: v_excess_part CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;

1133: and total_qoh > 0;
1134:
1135: x_excess_line_id number;
1136:
1137: v_excess_part CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
1138: begin
1139:
1140: for d in defectives loop
1141: if p_called_from = 'PART_STATUS' then

Line 1163: csp_excess_lists_pkg.Insert_Row(

1159: d.excess_quantity);
1160: else
1161: x_excess_line_id := null;
1162: /*
1163: csp_excess_lists_pkg.Insert_Row(
1164: px_EXCESS_LINE_ID => x_excess_line_id,
1165: p_CREATED_BY => fnd_global.user_id,
1166: p_CREATION_DATE => sysdate,
1167: p_LAST_UPDATED_BY => fnd_global.user_id,

Line 1197: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;

1193: p_ATTRIBUTE14 => null,
1194: p_ATTRIBUTE15 => null);
1195: */
1196:
1197: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
1198: v_excess_part.CREATED_BY := fnd_global.user_id;
1199: v_excess_part.CREATION_DATE := sysdate;
1200: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
1201: v_excess_part.LAST_UPDATE_DATE := sysdate;

Line 1987: p_excess_part IN OUT nocopy CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE,

1983: END get_shipped_qty;
1984:
1985: -- added by htank for Reverse Logistic project
1986: PROCEDURE populate_excess_list (
1987: p_excess_part IN OUT nocopy CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE,
1988: p_is_insert_record IN VARCHAR2 default 'Y'
1989: ) IS
1990:
1991: CURSOR c_get_return_info (cv_ORGANIZATION_ID NUMBER,

Line 2004: v_excess_records CSP_EXCESS_LISTS_PKG.EXCESS_TBL_TYPE;

2000: and CSI.ORGANIZATION_ID = cv_ORGANIZATION_ID;
2001:
2002: v_ret_org_id NUMBER;
2003: v_ret_sub_inv VARCHAR2(10);
2004: v_excess_records CSP_EXCESS_LISTS_PKG.EXCESS_TBL_TYPE;
2005: v_excess_part CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE;
2006: x_excess_line_id NUMBER;
2007:
2008: -- routing rule change

Line 2005: v_excess_part CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE;

2001:
2002: v_ret_org_id NUMBER;
2003: v_ret_sub_inv VARCHAR2(10);
2004: v_excess_records CSP_EXCESS_LISTS_PKG.EXCESS_TBL_TYPE;
2005: v_excess_part CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE;
2006: x_excess_line_id NUMBER;
2007:
2008: -- routing rule change
2009: v_return_rule_id number;

Line 2155: 'Calling csp_excess_lists_pkg.Insert_Row for i = ' || i);

2151:
2152: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2153: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2154: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2155: 'Calling csp_excess_lists_pkg.Insert_Row for i = ' || i);
2156: end if;
2157:
2158: csp_excess_lists_pkg.Insert_Row(
2159: px_EXCESS_LINE_ID => x_excess_line_id,

Line 2158: csp_excess_lists_pkg.Insert_Row(

2154: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2155: 'Calling csp_excess_lists_pkg.Insert_Row for i = ' || i);
2156: end if;
2157:
2158: csp_excess_lists_pkg.Insert_Row(
2159: px_EXCESS_LINE_ID => x_excess_line_id,
2160: p_CREATED_BY => v_excess_part.CREATED_BY,
2161: p_CREATION_DATE => v_excess_part.CREATION_DATE,
2162: p_LAST_UPDATED_BY => v_excess_part.LAST_UPDATED_BY,