APPS.GR_PROCESS_ORDERS dependencies on GR_DISPATCH_HISTORIES

Line 1783: L_BLANK_ATTRIBUTE gr_dispatch_histories.attribute1%TYPE;

1779: L_RETURN_STATUS VARCHAR2(1);
1780: L_STATUS VARCHAR2(1);
1781: L_MSG_DATA VARCHAR2(1000);
1782: L_KEY_EXISTS VARCHAR2(1);
1783: L_BLANK_ATTRIBUTE gr_dispatch_histories.attribute1%TYPE;
1784: L_BLANK_CATEGORY gr_dispatch_histories.attribute_category%TYPE;
1785: L_MSDS_DATE gr_dispatch_histories.date_msds_sent%TYPE;
1786:
1787: L_API_NAME CONSTANT VARCHAR2(30) := 'Update Dispatch History';

Line 1784: L_BLANK_CATEGORY gr_dispatch_histories.attribute_category%TYPE;

1780: L_STATUS VARCHAR2(1);
1781: L_MSG_DATA VARCHAR2(1000);
1782: L_KEY_EXISTS VARCHAR2(1);
1783: L_BLANK_ATTRIBUTE gr_dispatch_histories.attribute1%TYPE;
1784: L_BLANK_CATEGORY gr_dispatch_histories.attribute_category%TYPE;
1785: L_MSDS_DATE gr_dispatch_histories.date_msds_sent%TYPE;
1786:
1787: L_API_NAME CONSTANT VARCHAR2(30) := 'Update Dispatch History';
1788:

Line 1785: L_MSDS_DATE gr_dispatch_histories.date_msds_sent%TYPE;

1781: L_MSG_DATA VARCHAR2(1000);
1782: L_KEY_EXISTS VARCHAR2(1);
1783: L_BLANK_ATTRIBUTE gr_dispatch_histories.attribute1%TYPE;
1784: L_BLANK_CATEGORY gr_dispatch_histories.attribute_category%TYPE;
1785: L_MSDS_DATE gr_dispatch_histories.date_msds_sent%TYPE;
1786:
1787: L_API_NAME CONSTANT VARCHAR2(30) := 'Update Dispatch History';
1788:
1789: L_CURRENT_DATE CONSTANT DATE := sysdate;

Line 2107: GR_DISPATCH_HISTORIES_PKG.Check_Primary_Key

2103: /*
2104: ** Bug 2342375 Mercy Thomas 08/15/2002 End of the Code Changes
2105: */
2106:
2107: GR_DISPATCH_HISTORIES_PKG.Check_Primary_Key
2108: (BatchDetails.document_code,
2109: 1, /* Document text id */
2110: /*
2111: ** Bug 2342375 Mercy Thomas 08/15/2002 Changed the BatchDetails.item_code to l_item_code

Line 2123: GR_DISPATCH_HISTORIES_PKG.Insert_Row

2119: 'F',
2120: l_rowid,
2121: l_key_exists);
2122: IF NOT FND_API.TO_BOOLEAN(l_key_exists) THEN
2123: GR_DISPATCH_HISTORIES_PKG.Insert_Row
2124: (l_commit,
2125: l_called_by_form,
2126: BatchDetails.document_code,
2127: 1, /* Document text id */

Line 3956: FROM gr_dispatch_histories dh,

3952: IS
3953: SELECT ids.rebuild_item_doc_flag,
3954: ids.last_doc_update_date,
3955: dh.date_msds_sent
3956: FROM gr_dispatch_histories dh,
3957: gr_item_doc_statuses ids
3958: WHERE ids.item_code = g_item_code
3959: /* Fix for B1255401 */
3960: AND dh.dispatch_method_code <> 99

Line 3963: FROM gr_dispatch_histories dh1

3959: /* Fix for B1255401 */
3960: AND dh.dispatch_method_code <> 99
3961: AND ids.document_code = GlobalRecipient.document_code
3962: AND dh.date_msds_sent = (SELECT MAX(dh1.date_msds_sent)
3963: FROM gr_dispatch_histories dh1
3964: WHERE dh1.item_code = g_item_code
3965: AND dh1.document_code = GlobalRecipient.document_code
3966: AND dh1.recipient_code = g_recipient_code);
3967: LocalDispatchRcd c_get_last_dispatch%ROWTYPE;