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_PICK_SERIAL_LOTS_PVT dependencies on DBMS_SQL

Line 694: dbms_sql.define_column(p_cur_get_psl, 1, P_psl_Rec.PICKLIST_SERIAL_LOT_ID);

690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Define Columns Begins');
692:
693: -- define all columns for CSP_PICKLIST_SERIAL_LOTS_V view
694: dbms_sql.define_column(p_cur_get_psl, 1, P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);
696: dbms_sql.define_column(p_cur_get_psl, 3, P_psl_Rec.ORGANIZATION_ID);
697: dbms_sql.define_column(p_cur_get_psl, 4, P_psl_Rec.INVENTORY_ITEM_ID);
698: dbms_sql.define_column(p_cur_get_psl, 5, P_psl_Rec.QUANTITY);

Line 695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);

691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Define Columns Begins');
692:
693: -- define all columns for CSP_PICKLIST_SERIAL_LOTS_V view
694: dbms_sql.define_column(p_cur_get_psl, 1, P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);
696: dbms_sql.define_column(p_cur_get_psl, 3, P_psl_Rec.ORGANIZATION_ID);
697: dbms_sql.define_column(p_cur_get_psl, 4, P_psl_Rec.INVENTORY_ITEM_ID);
698: dbms_sql.define_column(p_cur_get_psl, 5, P_psl_Rec.QUANTITY);
699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);

Line 696: dbms_sql.define_column(p_cur_get_psl, 3, P_psl_Rec.ORGANIZATION_ID);

692:
693: -- define all columns for CSP_PICKLIST_SERIAL_LOTS_V view
694: dbms_sql.define_column(p_cur_get_psl, 1, P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);
696: dbms_sql.define_column(p_cur_get_psl, 3, P_psl_Rec.ORGANIZATION_ID);
697: dbms_sql.define_column(p_cur_get_psl, 4, P_psl_Rec.INVENTORY_ITEM_ID);
698: dbms_sql.define_column(p_cur_get_psl, 5, P_psl_Rec.QUANTITY);
699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);
700: dbms_sql.define_column(p_cur_get_psl, 7, P_psl_Rec.SERIAL_NUMBER, 30);

Line 697: dbms_sql.define_column(p_cur_get_psl, 4, P_psl_Rec.INVENTORY_ITEM_ID);

693: -- define all columns for CSP_PICKLIST_SERIAL_LOTS_V view
694: dbms_sql.define_column(p_cur_get_psl, 1, P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);
696: dbms_sql.define_column(p_cur_get_psl, 3, P_psl_Rec.ORGANIZATION_ID);
697: dbms_sql.define_column(p_cur_get_psl, 4, P_psl_Rec.INVENTORY_ITEM_ID);
698: dbms_sql.define_column(p_cur_get_psl, 5, P_psl_Rec.QUANTITY);
699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);
700: dbms_sql.define_column(p_cur_get_psl, 7, P_psl_Rec.SERIAL_NUMBER, 30);
701:

Line 698: dbms_sql.define_column(p_cur_get_psl, 5, P_psl_Rec.QUANTITY);

694: dbms_sql.define_column(p_cur_get_psl, 1, P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);
696: dbms_sql.define_column(p_cur_get_psl, 3, P_psl_Rec.ORGANIZATION_ID);
697: dbms_sql.define_column(p_cur_get_psl, 4, P_psl_Rec.INVENTORY_ITEM_ID);
698: dbms_sql.define_column(p_cur_get_psl, 5, P_psl_Rec.QUANTITY);
699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);
700: dbms_sql.define_column(p_cur_get_psl, 7, P_psl_Rec.SERIAL_NUMBER, 30);
701:
702: -- Debug Message

Line 699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);

695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);
696: dbms_sql.define_column(p_cur_get_psl, 3, P_psl_Rec.ORGANIZATION_ID);
697: dbms_sql.define_column(p_cur_get_psl, 4, P_psl_Rec.INVENTORY_ITEM_ID);
698: dbms_sql.define_column(p_cur_get_psl, 5, P_psl_Rec.QUANTITY);
699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);
700: dbms_sql.define_column(p_cur_get_psl, 7, P_psl_Rec.SERIAL_NUMBER, 30);
701:
702: -- Debug Message
703: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Define Columns Ends');

Line 700: dbms_sql.define_column(p_cur_get_psl, 7, P_psl_Rec.SERIAL_NUMBER, 30);

696: dbms_sql.define_column(p_cur_get_psl, 3, P_psl_Rec.ORGANIZATION_ID);
697: dbms_sql.define_column(p_cur_get_psl, 4, P_psl_Rec.INVENTORY_ITEM_ID);
698: dbms_sql.define_column(p_cur_get_psl, 5, P_psl_Rec.QUANTITY);
699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);
700: dbms_sql.define_column(p_cur_get_psl, 7, P_psl_Rec.SERIAL_NUMBER, 30);
701:
702: -- Debug Message
703: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Define Columns Ends');
704: END Define_Columns;

Line 717: dbms_sql.column_value(p_cur_get_psl, 1, X_psl_Rec.ROW_ID);

713: -- Debug Message
714: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Begins');
715:
716: -- get all column values for CSP_PICKLIST_SERIAL_LOTS_V table
717: dbms_sql.column_value(p_cur_get_psl, 1, X_psl_Rec.ROW_ID);
718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);
719: dbms_sql.column_value(p_cur_get_psl, 3, X_psl_Rec.PICKLIST_LINE_ID);
720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);
721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);

Line 718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);

714: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Begins');
715:
716: -- get all column values for CSP_PICKLIST_SERIAL_LOTS_V table
717: dbms_sql.column_value(p_cur_get_psl, 1, X_psl_Rec.ROW_ID);
718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);
719: dbms_sql.column_value(p_cur_get_psl, 3, X_psl_Rec.PICKLIST_LINE_ID);
720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);
721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);
722: dbms_sql.column_value(p_cur_get_psl, 6, X_psl_Rec.QUANTITY);

Line 719: dbms_sql.column_value(p_cur_get_psl, 3, X_psl_Rec.PICKLIST_LINE_ID);

715:
716: -- get all column values for CSP_PICKLIST_SERIAL_LOTS_V table
717: dbms_sql.column_value(p_cur_get_psl, 1, X_psl_Rec.ROW_ID);
718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);
719: dbms_sql.column_value(p_cur_get_psl, 3, X_psl_Rec.PICKLIST_LINE_ID);
720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);
721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);
722: dbms_sql.column_value(p_cur_get_psl, 6, X_psl_Rec.QUANTITY);
723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);

Line 720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);

716: -- get all column values for CSP_PICKLIST_SERIAL_LOTS_V table
717: dbms_sql.column_value(p_cur_get_psl, 1, X_psl_Rec.ROW_ID);
718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);
719: dbms_sql.column_value(p_cur_get_psl, 3, X_psl_Rec.PICKLIST_LINE_ID);
720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);
721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);
722: dbms_sql.column_value(p_cur_get_psl, 6, X_psl_Rec.QUANTITY);
723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);
724: dbms_sql.column_value(p_cur_get_psl, 8, X_psl_Rec.SERIAL_NUMBER);

Line 721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);

717: dbms_sql.column_value(p_cur_get_psl, 1, X_psl_Rec.ROW_ID);
718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);
719: dbms_sql.column_value(p_cur_get_psl, 3, X_psl_Rec.PICKLIST_LINE_ID);
720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);
721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);
722: dbms_sql.column_value(p_cur_get_psl, 6, X_psl_Rec.QUANTITY);
723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);
724: dbms_sql.column_value(p_cur_get_psl, 8, X_psl_Rec.SERIAL_NUMBER);
725:

Line 722: dbms_sql.column_value(p_cur_get_psl, 6, X_psl_Rec.QUANTITY);

718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);
719: dbms_sql.column_value(p_cur_get_psl, 3, X_psl_Rec.PICKLIST_LINE_ID);
720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);
721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);
722: dbms_sql.column_value(p_cur_get_psl, 6, X_psl_Rec.QUANTITY);
723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);
724: dbms_sql.column_value(p_cur_get_psl, 8, X_psl_Rec.SERIAL_NUMBER);
725:
726: -- Debug Message

Line 723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);

719: dbms_sql.column_value(p_cur_get_psl, 3, X_psl_Rec.PICKLIST_LINE_ID);
720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);
721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);
722: dbms_sql.column_value(p_cur_get_psl, 6, X_psl_Rec.QUANTITY);
723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);
724: dbms_sql.column_value(p_cur_get_psl, 8, X_psl_Rec.SERIAL_NUMBER);
725:
726: -- Debug Message
727: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Ends');

Line 724: dbms_sql.column_value(p_cur_get_psl, 8, X_psl_Rec.SERIAL_NUMBER);

720: dbms_sql.column_value(p_cur_get_psl, 4, X_psl_Rec.ORGANIZATION_ID);
721: dbms_sql.column_value(p_cur_get_psl, 5, X_psl_Rec.INVENTORY_ITEM_ID);
722: dbms_sql.column_value(p_cur_get_psl, 6, X_psl_Rec.QUANTITY);
723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);
724: dbms_sql.column_value(p_cur_get_psl, 8, X_psl_Rec.SERIAL_NUMBER);
725:
726: -- Debug Message
727: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Ends');
728: END Get_Column_Values;

Line 789: DBMS_SQL.BIND_VARIABLE(p_cur_get_psl, ':p_PICKLIST_SERIAL_LOT_ID', P_psl_Rec.PICKLIST_SERIAL_LOT_ID);

785: -- The following example applies to all columns,
786: -- developers can copy and paste them.
787: IF( (P_psl_Rec.PICKLIST_SERIAL_LOT_ID IS NOT NULL) AND (P_psl_Rec.PICKLIST_SERIAL_LOT_ID <> FND_API.G_MISS_NUM) )
788: THEN
789: DBMS_SQL.BIND_VARIABLE(p_cur_get_psl, ':p_PICKLIST_SERIAL_LOT_ID', P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
790: END IF;
791:
792: -- Debug Message
793: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Bind Variables Ends');